in

SMSUG.ca

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

Browse by Tags

  • List new CM clients within the last 14 days.

    For full details, please see http://social.technet.microsoft.com/Forums/en-US/configmgrsetup/thread/2f072158-88c2-48e9-8125-2e137494fbeb select Creation_Date0, Name0, User_Name0 from dbo.v_R_System where datediff(dd,Creation_Date0, getdate()) < 14 and Client0 = 1
    Posted to Garth Jones (Weblog) by Garth on 12-31-2012
  • How to find all workstations with SNMP.

    For full detail please see, http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/thread/2eb10f29-0927-4b43-a4a4-0c712793673f Select CS.Name0 as 'PC Name' , OS.Caption0 as 'OS' , OS.CSDVersion0 as 'SP' From dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_SERVICE S on CS...
    Posted to Garth Jones (Weblog) by Garth on 12-29-2012
  • File not in a list

    For full detail , please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/688bff46-a0ed-44cb-84c2-df036fe40e84 select SF.* from dbo.v_GS_SoftwareFile SF Where FileName not in ( 'sol.exe' , 'freecell.exe' ) and FileName like '%.exe'
    Posted to Garth Jones (Weblog) by Garth on 12-28-2012
  • PC with MAC Address

    For full details see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/6c00b44f-1b92-4c1b-924e-fd79c191d5e9 Select R.Netbios_Name0, MAC.MAC_Addresses0 from dbo.v_R_System R join dbo.v_RA_System_MACAddresses MAC ON R.ResourceID = MAC.ResourceID Where MAC.MAC_Addresses0 in ( SELECT...
    Posted to Garth Jones (Weblog) by Garth on 11-17-2012
  • Softwares installed in last 90 days on a collection of PC

    For full details, please see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/80c794d7-a55f-4d13-985b-9b84efd6f9e7   SELECT R.Name0 as 'PC' , CS.Manufacturer0 as 'Man' , CS.Model0 as 'Model' , ARP.DisplayName0 as 'DisplayName' , ARP.Version0...
    Posted to Garth Jones (Weblog) by Garth on 11-17-2012
  • How to find an application installed in the last 7 days

    For full details see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/38f96191-6e3e-4150-8f3a-18b1c4db8d7d SELECT R.Netbios_name0, R.AD_Site_Name0, ARP.DisplayName0, ARP.InstallDate0, DATEDIFF( Day , CONVERT ( Datetime ,ARP.InstallDate0), GETDATE()) AS [days since installed...
    Posted to Garth Jones (Weblog) by Garth on 07-02-2012
  • Finding Adobe X for both x68 and x64

    For full details see http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/66c80e66-9760-49b3-b429-08bf2ca8f572 http://social.technet.microsoft.com/Forums/en-US/configmanagerapps/thread/b68ce42c-98f5-4500-bced-0e8e901cb211/ select distinct SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType...
    Posted to Garth Jones (Weblog) by Garth on 07-02-2012
  • Query on user history

    For full details please see http://www.myitforum.com/Forums/tm.aspx?m=230539&high = SELECT DISTINCT R.Netbios_Name0, tu.SystemConsoleUser0, tu.logontime FROM dbo.v_R_System R join ( SELECT husr.ResourceID, Husr.SystemConsoleUser0, max (Husr.LastConsoleUse0) as logontime FROM dbo.v_HS_SYSTEM_CONSOLE_USER...
    Posted to Garth Jones (Weblog) by Garth on 07-01-2012
  • Query for computers with single partition

    For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/thread/4d84e5f9-fd48-4fcb-b490-d0a64052aa08 select SMS_R_System.Name from SMS_R_System where SMS_R_System.ResourceId not in ( select SMS_G_System_PARTITION.ResourceId from SMS_G_System_PARTITION where SMS_G_System_PARTITION...
    Posted to Garth Jones (Weblog) by Garth on 06-09-2012
  • List of PCs with Project, Visio or Visual

    For full details, please see this forum post. http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/50b2b524-3c11-41c5-a2d5-b8ae979ee3c2/ Select sys.Netbios_Name0, sys.User_Domain0, sys.User_Name0, sys.Operating_System_Name_and0, arp.DisplayName0, ARP.Version0 FROM v_R_System sys...
    Posted to Garth Jones (Weblog) by Garth on 06-01-2012
Page 3 of 48 (479 items) < Previous 1 2 3 4 5 Next > ... Last ยป
©2010 SMSUG.ca Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems