→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎09-03-2009 07:04 PM
‎11-20-2009 08:39 PM
‎11-20-2009 04:29 PM
‎09-09-2009 06:31 AM
Select Top 100 Percent tblUsers.SID, Count(tblUsers.UserID) As Total
From dbo.tblComputers Inner Join
tblUsers On dbo.tblComputers.Computername = tblUsers.Computername
Group By tblUsers.SID
Having tblUsers.SID Like '%-500'
‎09-09-2009 12:32 AM
Set objWMIService = GetObject("winmgmts:\\.\root\cimv2")
Set colAccounts = objWMIService.ExecQuery _
("Select * From Win32_UserAccount Where LocalAccount=True")
Result = ""
For Each objAccount in colAccounts
If Left (objAccount.SID, 6) = "S-1-5-" and Right(objAccount.SID, 4) = "-500" Then
CompSID=Left (objAccount.SID,len(objAccount.SID)-4)
Result = CompSID
End If
Next
MsgBox "SID is: " & Result
‎09-04-2009 05:50 PM
‎09-04-2009 05:31 PM
‎09-04-2009 05:05 PM
‎09-04-2009 12:14 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now