Browse by Tags

All Tags » System Center (RSS)
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: , , , , , , ,
How to exclude a collection from sccm collection query
Saturday, May 19, 2012 10:47 AM
For full details, see this forums post. http://social.technet.microsoft.com/Forums/en-US/configmgrinventory/thread/75288b97-1fe6-4634-a20a-54091bba8d91   select SMS_R_SYSTEM.ResourceID, SMS_R_SYSTEM.ResourceType, SMS_R_SYSTEM.Name, SMS_R_SYSTEM.SMSUniqueIdentifier, SMS_R_SYSTEM.ResourceDomainORWorkgroup, SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SoftwareFile... 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: , , , , , , , , ,
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: , , , , ,
78!
Tuesday, March 13, 2012 10:06 PM
I have been told that we are 78 people short of the 1200 people for tomorrows Webcast! Will you be the one to help set a new record for myITForm webcast? Sign up now! http://bit.ly/yMimvp   And don’t forget that I have BIG news to spill at the end of the Webcast! 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: , , , , , ,
BIG NEWS!!!!
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! http://bit.ly/yMimvp   oh, you want a hint?!?! Just a little hint??? Let’s just say that it involves... Read More...
by Garth Jones
Filed under: , , , , , , , , ,
Display the User Group Name in 1 column
Friday, February 17, 2012 8:43 AM
To see full forum post see http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/986960ba-8a50-4e69-9e5a-64a40c9d8df5/ SELECT R.User_Name0 as ' user name ', U.Full_User_Name0 as ' full name ', U.givenName0 as ' First Name ', U.sn0 as ' Surname ', U.mail0 as ' Email ', max (OU.User_OU_Name0) as '... Read More...
by Garth Jones
Filed under: , , , , ,
PC not logon for 14 days.
Monday, February 06, 2012 9:04 PM
For full details see. http://social.technet.microsoft.com/Forums/en-US/configmgrsdk/thread/cf7d80a0-1a7c-430c-b33a-ee47a0efa806   select CS.Name0, LCU. date From dbo.v_GS_COMPUTER_SYSTEM CS join ( Select ResourceID, max (LastConsoleUse0) as ' date ' from dbo.v_GS_SYSTEM_CONSOLE_USER SCU Group by ResourceID) as LCU on CS.ResourceID = LCU.ResourceID... Read More...
by Garth Jones
Filed under: , , , , , , ,
WQL Query for both x86 and x64 version of Software
Monday, January 16, 2012 5:27 PM
  select distinct SMS_R_System.Name, SMS_R_System.ResourceId from SMS_R_System where SMS_R_System.ResourceId in ( select SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID from SMS_G_System_ADD_REMOVE_PROGRAMS where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName = " Microsoft Lync 2010 ") or SMS_R_System.ResourceId in ( select SMS_G_System_ADD_REMOVE_PROGRAMS_64... Read More...
by Garth Jones
Filed under: , , , ,
MyITforum donation for 2012
Monday, January 02, 2012 10:21 AM
With the start of a new year, it is that time again to support the System Center Community, with that in mind I have made my yearly donation of $250 USD to MyITForum (MIF). http://myitforum.com/myitforumwp/aboutus/donations/   MIF is truly a community that helps each other both professionally and personally. But it cost thousands of dollars each MONTH to... Read More...
by Garth Jones
Filed under: , , , , , , , , , , , , , ,
Report Two items from Add/Remove Program
Tuesday, December 20, 2011 7:00 PM
Select Name0 From dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_FullCollectionMembership FCM on CS.ResourceID = FCM.ResourceID Where CS.ResourceId in ( select ARP.ResourceId from dbo.v_Add_Remove_Programs ARP Where ARP.Displayname0 = ' Windows Server 2003 Service Pack 2 ') and CS.ResourceId in ( select ARP.ResourceId from dbo.v_Add_Remove_Programs ARP Where... Read More...
by Garth Jones
Filed under: , , , ,
Query to find multiple Net bois names on single IP
Thursday, November 24, 2011 8:51 AM
http://social.technet.microsoft.com/Forums/en-US/configmgrai/thread/c23b6c8f-57a7-4bdf-932e-e28060d4323d select CS.Name0, NAC.IPAddress0 from dbo.v_GS_COMPUTER_SYSTEM CS join dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC on CS.ResourceID = NAC.ResourceID Where NAC.IPAddress0 != '' Group by CS.Name0, NAC.IPAddress0 Having count (NAC.IPAddress0) > 1 .csharpcode... Read More...
by Garth Jones
Filed under: , , , , ,
More Posts Next page »
Go

This Blog

Syndication