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

Browse by Tags

  • Finding Adobe X for both x68 and x64

    For full details see 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 = 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: 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. 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
  • Find Programs Removed from a PC (updated)

    For full details see: SELECT DISTINCT CS.Name0, HARP.Publisher0 AS ' Publisher ', HARP.ProdID0 AS ' Product ', HARP.DisplayName0 AS ' Name ' FROM dbo.v_GS_COMPUTER_SYSTEM...
    Posted to Garth Jones (Weblog) by Garth on 05-21-2012
  • How to exclude a collection from sccm collection query

    For full details, see this forums post.   select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup...
    Posted to Garth Jones (Weblog) by Garth on 05-19-2012
  • List of PC with Project and Subnet

    For full details, see posts:   select Distinct CS.Name0 from dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_Add_Remove_Programs ARP on CS...
    Posted to Garth Jones (Weblog) by Garth on 05-03-2012
  • Query to report OU information for Machines

    For full details please see:   select R.Name0, max (OU.System_OU_Name0) From dbo.v_R_System R join dbo.v_RA_System_SystemOUName OU on OU.ResourceID = R.ResourceID join dbo.v_FullCollectionMembership FCM on FCM...
    Posted to Garth Jones (Weblog) by Garth on 04-05-2012
  • Last Reboot Report

    For full details see:   select distinct R.ResourceID, R.Netbios_Name0 AS ' Computer Name ', OS.LastBootUpTime0 AS ' Last Boot Time ', R.Resource_Domain_OR_Workgr0 AS '...
    Posted to Garth Jones (Weblog) by Garth on 03-18-2012
  • Lists people and how much they've been using specified software with OU fix

    For full details see: select U.Name0 as ' Bruger ', -- U.displayName0 as 'Bruger', MU.FullName as ' Brugernavn ', ou.ou as OU, round( sum (MUS.UsageTime)/60.0,2) as ' Forbrug (min) ' from dbo...
    Posted to Garth Jones (Weblog) by Garth on 03-16-2012
Page 5 of 41 (402 items) « First ... < Previous 3 4 5 6 7 Next > ... Last »
©2010 Privacy Statement
Powered by Community Server (Non-Commercial Edition), by Telligent Systems