Browse by Tags

All Tags » SCCM » vNext (RSS)
How to find all workstations with SNMP.
Saturday, December 29, 2012 11:39 AM
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.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 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] 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 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, 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 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 Husr WHERE Husr.SystemConsoleUser0 LIKE ' Gartek... Read More...
by Garth Jones
Filed under: , , , , , ,
List of PCs with Project, Visio or Visual
Friday, June 01, 2012 7:53 AM
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 JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID... Read More...
by Garth Jones
Filed under: , , , , ,
Find Programs Removed from a PC (updated)
Monday, May 21, 2012 10:15 AM
For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrgeneral/thread/db96da44-a9e0-4996-bca2-286b6e2c473a SELECT DISTINCT CS.Name0, HARP.Publisher0 AS ' Publisher ', HARP.ProdID0 AS ' Product ', HARP.DisplayName0 AS ' Name ' FROM dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_ADD_REMOVE_PROGRAMS ARP on ARP.ResourceID... 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...
by Garth Jones
Filed under: , , , , , , , , ,
Last Reboot Report
Sunday, March 18, 2012 12:38 PM
For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/e0147d8a-8946-42bb-b6ed-a3c92bae5b23   select distinct R.ResourceID, R.Netbios_Name0 AS ' Computer Name ', OS.LastBootUpTime0 AS ' Last Boot Time ', R.Resource_Domain_OR_Workgr0 AS ' Domain/Workgroup ', S.SiteCode as ' SMS Site Code... Read More...
by Garth Jones
Filed under: , , , , ,
Lists people and how much they've been using specified software with OU fix
Friday, March 16, 2012 6:53 PM
For full details see: http://www.myitforum.com/forums/tm.aspx?high=&m=234978&mpage=1#234980   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.v_R_System R join dbo.v_MonthlyUsageSummary MUS on R... Read More...
by Garth Jones
Filed under: , , , , ,
Lists people and how much they've been using specified software
Friday, March 16, 2012 6:40 AM
For full details see: http://www.myitforum.com/forums/Need-some-SQL-help-think-its-simple-m234978.aspx   select U.Name0 as ' Bruger ', -- U.displayName0 as 'Bruger', MU.FullName as ' Brugernavn ', replace( max (ou.User_OU_Name0),' ITCSYD.LOCAL/BRUGERE/ ',' ') as OU, round( sum (MUS.UsageTime)/60.0,2) as ' Forbrug... Read More...
by Garth Jones
Filed under: , , , , ,
List collection name and number of resources by OS
Wednesday, March 14, 2012 3:49 PM
For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/370ceff1-0f54-46f3-8e8e-5459069125e4     SELECT C.Name, OS.Caption0 as ' Operating System ', OS.CSDVersion0 as ' Service Pack ', COUNT (*) AS ' Count ' FROM dbo.v_R_System R join dbo.v_GS_OPERATING_SYSTEM OS on OS.Resourceid = R.Resourceid... Read More...
by Garth Jones
Filed under: , , , , ,
Report for matching names
Monday, March 12, 2012 11:53 AM
For full details see: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/8bda0fe9-7d80-44d0-9a52-f1f573423abf/   select CS.ResourceID, cs.NAME0, PC2.name0, substring (CS.NAME0,5,LEN(cs.NAME0)) from dbo.v_GS_COMPUTER_SYSTEM CS, ( select CS.ResourceID, cs.NAME0, substring (CS.NAME0,5,LEN(cs.NAME0)) as ' TAG ' from dbo.v_GS_COMPUTER_SYSTEM... Read More...
by Garth Jones
Filed under: , , , , ,
Total SQL Server Systems Query
Monday, March 12, 2012 10:19 AM
See forum post for full details: http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/51ead03a-a43d-46df-b0ab-059d9322e432   SELECT DISTINCT R.Name0, R.User_Name0, ARP.DisplayName0 AS [Software Name], ARP.Version0 AS [Installed Version], IP.IP_Addresses0 AS IPAddress, -- ARP.TimeStamp AS [Last Time Stamp], ARP.InstallDate0 AS [Software... Read More...
by Garth Jones
Filed under: , , , , , ,
Link v_MeteredUser.FullName to a full name from AD v2
Monday, March 12, 2012 10:10 AM
To see full post see http://www.myitforum.com/forums/tm.aspx?high=&m=234899&mpage=1#234905 select R.Netbios_Name0 as ' Computernavn ', -- U.displayName0 as 'Bruger', Full_User_Name0, max (ou.User_OU_Name0), MU.FullName as ' Brugernavn ', MUS.LastUsage as ' Sidst brugt ', MUS.UsageCount + MUS.TSUsageCount as ' Antal... Read More...
by Garth Jones
Filed under: , , , , ,
Link v_MeteredUser.FullName to a full name from ad
Monday, March 12, 2012 8:34 AM
To see the full post http://www.myitforum.com/forums/How-to-link-v_MeteredUserFullName-to-a-full-name-from-ad-m234899.aspx select R.Netbios_Name0 as ' Computernavn ', -- U.displayName0 as 'Bruger', Full_User_Name0, MU.FullName as ' Brugernavn ', MUS.LastUsage as ' Sidst brugt ', MUS.UsageCount + MUS.TSUsageCount as ' Antal... Read More...
by Garth Jones
Filed under: , , , , , ,
More Posts Next page »
Go

This Blog

Syndication