Browse by Tags

How to find all workstations with SNMP.
Saturday, December 29, 2012 11:39 AM
For full detail please see, 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.ResourceID = S.ResourceID join dbo.v_GS_SYSTEM SYS on CS.ResourceID... Read More...
by Garth Jones
Filed under: , , , , , , , ,
How to find an application installed in the last 7 days
Monday, July 02, 2012 9:27 PM
For full details see SELECT R.Netbios_name0, R.AD_Site_Name0, ARP.DisplayName0, ARP.InstallDate0, DATEDIFF( Day , CONVERT ( Datetime ,ARP.InstallDate0), GETDATE()) AS [days since installed] FROM dbo.v_R_System R join dbo.v_FullCollectionMembership FCM... Read More...
by Garth Jones
Filed under: , , , , , , ,
Finding Adobe X for both x68 and x64
Monday, July 02, 2012 9:45 AM
For full details see select distinct SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier... Read More...
by Garth Jones
Filed under: , , , , , ,
Query on user history
Sunday, July 01, 2012 9:37 AM
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 Husr WHERE Husr.SystemConsoleUser0 LIKE ' Gartek... Read More...
by Garth Jones
Filed under: , , , , , ,
MMS 2012
Monday, April 30, 2012 9:01 AM
Well MMS 2012 is over and it has been crazy for me. Here is the summary of what happened:   My passport expired so had to get a new one, I picked it up on Thursday just before I left for Vegas I know my luggage would be close to being overweight, so I didn’t bring a few things like shaving cream. I’m glad Walgreens is right there. I arrive at the airport... Read More...
Sunday, March 11, 2012 10:40 PM
I have big news but there is a catch….. I can’t say much until Wednesday at noon PST! J Which works out perfectly, as that is almost the exact time that I will be finishing my SCCM Guru webcast! So make sure that your register for the session to hear it Live!   oh, you want a hint?!?! Just a little hint??? Let’s just say that it involves... Read More...

This Blog