public static bool DoSyncStartups()
{
try
{
Network net;
net = Utilities.ConnectNetwork(0);
if (net == null)
{
return(false);
}
Status.UpdateMessage(0, "Collecting startups (HKLM)");
ListStartupItems Finaldata = new ListStartupItems();
Finaldata.Items = new List <StartupItem>();
Finaldata.MachineID = SystemInfos.SysInfo.MachineID;
Finaldata.SIDUsers = new List <string>();
ListStartupItems data = CollectInfosReg(Registry.LocalMachine, "SOFTWARE\\Microsoft\\Windows\\CurrentVersion\\Run", "SOFTWARE\\Wow6432Node\\Microsoft\\Windows\\CurrentVersion\\Run", "");
if (data == null)
{
return(false);
}
Finaldata.Items.AddRange(data.Items);
foreach (string kvp in Userregistries.GetLoadedUserRegistries())
{
Status.UpdateMessage(0, "Collecting startups (" + kvp + ")");
Finaldata.SIDUsers.Add(kvp);
data = CollectInfosReg(Registry.Users, kvp + "\\SOFTWARE\\Microsoft\\Windows\\CurrentVersion\\Run", kvp + "\\SOFTWARE\\Wow6432Node\\Microsoft\\Windows\\CurrentVersion\\Run", kvp);
if (data == null)
{
continue;
}
Finaldata.Items.AddRange(data.Items);
}
Status.UpdateMessage(0, "Reporting startups");
net.ReportStartups(Finaldata);
net.CloseConnection();
}
catch (Exception ee)
{
Debug.WriteLine(ee.ToString());
FoxEventLog.WriteEventLog("Servere error while syncing Startups: " + ee.ToString(), EventLogEntryType.Error);
}
Status.UpdateMessage(0);
return(true);
}
static ListStartupItems CollectInfosReg(RegistryKey RegPart, string RegBranch, string RegBranchWOW32, string HKCUUser)
{
ListStartupItems data = new ListStartupItems();
data.MachineID = SystemInfos.SysInfo.MachineID;
data.Items = new List <StartupItem>();
RegistryKey reg = RegPart.OpenSubKey(RegBranch, false);
if (reg != null)
{
foreach (string key in reg.GetValueNames())
{
StartupItem s = new StartupItem();
s.Location = "REG";
s.Key = key;
s.Item = Convert.ToString(reg.GetValue(key));
s.HKCUUser = HKCUUser;
if (string.IsNullOrWhiteSpace(s.Key) == true)
{
s.Key = "(Default)";
}
data.Items.Add(s);
}
reg.Close();
}
if (SystemInfos.SysInfo.CPU == "EM64T")
{
reg = RegPart.OpenSubKey(RegBranchWOW32, false);
if (reg != null)
{
foreach (string key in reg.GetValueNames())
{
StartupItem s = new StartupItem();
s.Location = "REG_WOW";
s.Key = key;
s.Item = Convert.ToString(reg.GetValue(key));
s.HKCUUser = HKCUUser;
if (string.IsNullOrWhiteSpace(s.Key) == true)
{
s.Key = "(Default)";
}
data.Items.Add(s);
}
reg.Close();
}
}
return(data);
}
public RESTStatus ReportStatups(SQLLib sql, ListStartupItems StartupList, NetworkConnectionInfo ni)
{
if (ni.HasAcl(ACLFlags.ComputerLogin) == false)
{
ni.Error = "Access denied";
ni.ErrorID = ErrorFlags.AccessDenied;
return(RESTStatus.Denied);
}
StartupList.MachineID = ni.Username;
lock (ni.sqllock)
{
if (Convert.ToInt32(sql.ExecSQLScalar("SELECT COUNT(*) FROM ComputerAccounts WHERE MachineID=@m",
new SQLParam("@m", StartupList.MachineID))) == 0)
{
ni.Error = "Invalid MachineID";
ni.ErrorID = ErrorFlags.InvalidValue;
return(RESTStatus.Denied);
}
}
if (StartupList.Items == null)
{
ni.Error = "Invalid Items";
ni.ErrorID = ErrorFlags.InvalidValue;
return(RESTStatus.Fail);
}
if (StartupList.SIDUsers == null)
{
StartupList.SIDUsers = new List <string>();
}
foreach (StartupItem rep in StartupList.Items)
{
if (string.IsNullOrWhiteSpace(rep.Location) == true)
{
ni.Error = "Invalid Items";
ni.ErrorID = ErrorFlags.InvalidValue;
return(RESTStatus.Fail);
}
if (string.IsNullOrWhiteSpace(rep.Key) == true)
{
ni.Error = "Invalid Items";
ni.ErrorID = ErrorFlags.InvalidValue;
return(RESTStatus.Fail);
}
if (string.IsNullOrWhiteSpace(rep.HKCUUser) == true)
{
rep.HKCUUser = "";
}
if (string.IsNullOrWhiteSpace(rep.Item) == true)
{
rep.Item = "";
}
}
List <StartupItem> Installed = new List <StartupItem>();
List <StartupItem> Reported = StartupList.Items;
lock (ni.sqllock)
{
SqlDataReader dr = sql.ExecSQLReader("SELECT * FROM Startups WHERE MachineID=@id", new SQLParam("@id", StartupList.MachineID));
while (dr.Read())
{
StartupItem ar = new StartupItem();
ar.Location = Convert.ToString(dr["Location"]);
ar.Key = Convert.ToString(dr["Key"]);
ar.Item = Convert.ToString(dr["Item"]);
ar.HKCUUser = Convert.ToString(dr["HKCUUser"]);
if (string.IsNullOrWhiteSpace(ar.HKCUUser) == true)
{
ar.HKCUUser = "";
}
Installed.Add(ar);
}
dr.Close();
}
List <StartupItem> Updated = new List <StartupItem>();
List <StartupItem> Unchanged = new List <StartupItem>();
List <StartupItem> Removed = new List <StartupItem>();
List <StartupItem> Added = new List <StartupItem>();
foreach (StartupItem inst in Installed)
{
inst.Location = inst.Location.Trim();
inst.Key = inst.Key.Trim();
inst.Item = inst.Item.Trim();
inst.HKCUUser = inst.HKCUUser.Trim();
bool Found = false;
foreach (StartupItem rep in Reported)
{
rep.Location = rep.Location.Trim();
rep.Key = rep.Key.Trim();
rep.Item = rep.Item.Trim();
rep.HKCUUser = rep.HKCUUser.Trim();
if (rep.Location.ToLower() == inst.Location.ToLower() && rep.Key == inst.Key && rep.HKCUUser == inst.HKCUUser)
{
if (rep.Item.ToLower() == inst.Item.ToLower())
{
Unchanged.Add(rep);
Found = true;
break;
}
else
{
Updated.Add(rep);
Found = true;
break;
}
}
}
if (Found == false)
{
if (inst.HKCUUser != "" && StartupList.SIDUsers.Contains(inst.HKCUUser, StringComparer.InvariantCultureIgnoreCase) == false)
{
//likely that this user is not logged on or such
Unchanged.Add(inst);
}
else
{
Removed.Add(inst);
}
}
}
foreach (StartupItem inst in Reported)
{
bool Found = false;
foreach (StartupItem rep in Installed)
{
if (rep.Key.ToLower() == inst.Key.ToLower() && rep.Location == inst.Location && rep.HKCUUser == inst.HKCUUser)
{
Found = true;
break;
}
}
if (Found == false)
{
Added.Add(inst);
}
}
lock (ni.sqllock)
{
try
{
sql.BeginTransaction();
sql.SEHError = true;
foreach (StartupItem ar in Removed)
{
sql.ExecSQL("DELETE FROM Startups WHERE MachineID=@id AND [Key]=@key AND Location=@location AND HKCUUser=@user",
new SQLParam("@id", StartupList.MachineID),
new SQLParam("@key", ar.Key),
new SQLParam("@user", ar.HKCUUser),
new SQLParam("@location", ar.Location));
}
foreach (StartupItem ar in Updated)
{
sql.ExecSQL(@"UPDATE Startups SET
Item=@item,
DT=@DT
WHERE MachineID=@id AND [Key]=@key AND Location=@location AND HKCUUser=@user",
new SQLParam("@id", StartupList.MachineID),
new SQLParam("@key", ar.Key),
new SQLParam("@user", ar.HKCUUser),
new SQLParam("@location", ar.Location),
new SQLParam("@item", ar.Item),
new SQLParam("@DT", DateTime.UtcNow));
}
foreach (StartupItem ar in Added)
{
sql.InsertMultiData("Startups",
new SQLData("MachineID", StartupList.MachineID),
new SQLData("Item", ar.Item),
new SQLData("Location", ar.Location),
new SQLData("Key", ar.Key),
new SQLData("HKCUUser", ar.HKCUUser),
new SQLData("DT", DateTime.UtcNow));
}
sql.CommitTransaction();
}
catch (Exception ee)
{
sql.RollBackTransaction();
FoxEventLog.WriteEventLog("DB Error: Cannot update Startups: " + ee.ToString(), System.Diagnostics.EventLogEntryType.Error);
return(RESTStatus.ServerError);
}
finally
{
sql.SEHError = false;
}
}
StartupLst l = new StartupLst();
l.Added = Added;
l.Removed = Removed;
l.Unchanged = Unchanged;
l.Updated = Updated;
l.MachineID = StartupList.MachineID;
Thread t = new Thread(new ParameterizedThreadStart(new DReportingThread(ReportingThread)));
t.Start(l);
return(RESTStatus.Created);
}
