in

SMSUG.ca

...your virtual communITy
All Tags » vNext (RSS)

Browse by Tags

  • List of Random PCs by Condition

    Here is a nice and simple way to get a list of Random PCs.   Create a query based on what you want to find, in my example Windows XP. Then add to the query a condition to find those with a “3” as the last character in the SMSID, Since the SMSID/GUID is HEX this will give you ~1/16 of all of those...
    Posted to Garth Jones (Weblog) by Garth on 06-16-2010
  • Vista without SP1 or SP2 (WQL)

    select     R.Name,     OS.Caption,     OS.CSDVersion from      SMS_R_System R     inner join SMS_G_System_OPERATING_SYSTEM OS on OS.ResourceID = R.ResourceId where     OS.CSDVersion is null    ...
    Posted to Garth Jones (Weblog) by Garth on 06-13-2010
  • Outlook.exe FILEPATH LIKE '%\Microsoft Office\OFFICE%'

    select SYS.Netbios_Name0, SF.FileName, SF.FileDescription, SF.FileVersion, SF.FileSize, SF.FileModifiedDate, SF.FilePath From v_GS_SoftwareFile SF join v_R_System SYS on SYS.ResourceID = SF.ResourceID Where SF.FileName = 'OUTLOOK.EXE' AND FILEPATH LIKE '%\Microsoft Office\OFFICE%' ORDER...
    Posted to Garth Jones (Weblog) by Garth on 06-12-2010
Page 7 of 7 (63 items) « First ... < Previous 3 4 5 6 7
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems