Browse by Tags

All Tags » SCCM » System Center (RSS)
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: , , , , ,
Don’t you love emails like this one!
Monday, November 14, 2011 10:21 PM
I left ITProTeach (DevTeach) a bit early so that I could head home to pack before my long overdue vacation! After getting back, I found this nice surprise in my inbox!   If you want to download the PPT, you can find it in Enhansoft’s blog http://support.enhansoft.com/Blogs/post/Diving-Deep-in-the-SCCM-data!-Bring-your-Swim-trunks!-e28093-Part-2.aspx http... Read More...
by Garth Jones
Filed under: , , , , ,
Two Software Titles
Wednesday, October 19, 2011 10:47 PM
SELECT DISTINCT a.Netbios_Name0 AS 'Computer Name' , CASE WHEN ARP.OMSA IS NULL THEN 'N/A' ELSE ARP.OMSA END AS 'Dell OMSA Version' , CASE WHEN ARP.Equallogic IS NULL THEN 'N/A' ELSE ARP.Equallogic END AS 'Broadcom Version' FROM v_R_System_Valid a INNER JOIN v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = a.ResourceID INNER... Read More...
by Garth Jones
Filed under: , , , ,
Query to fetch the machines from a specific OU with the Specific Machine Model
Tuesday, September 13, 2011 7:41 AM
Select R . Name0 From dbo . v_R_System R join dbo . v_GS_COMPUTER_SYSTEM CS on R . ResourceID = CS . ResourceID join dbo . v_RA_System_SystemOUName OU on R . ResourceID = OU . ResourceID Where CS . Model0 = 'Virtual Machine' Group by R . Name0 , CS . Model0 Having max ( OU . System_OU_Name0 ) = 'GARTEK.TST/WORKSTATIONS' Read More...
by Garth Jones
Filed under: , , , ,
PC Var data
Sunday, August 28, 2011 4:38 PM
select Name , Value , Masked from MEP_MachineVariables where MachineID = 63 Read More...
by Garth Jones
Filed under: , , , , , ,
RAM by User name
Saturday, August 06, 2011 2:00 PM
SELECT Distinct SYS.Netbios_Name0 , SYS.Operating_System_Name_and0 , MEM . TotalPhysicalMemory0 / 1024 As C083 FROM v_R_System SYS JOIN v_GS_X86_PC_MEMORY MEM on SYS.ResourceID = MEM . ResourceID WHERE User_Name0 = 'Garth' Read More...
by Garth Jones
Filed under: , , , , , ,
Modified version of “Hardware 03B - Computers for a specific primary console user”
Wednesday, June 08, 2011 7:19 AM
Select D istinct R . Netbios_Name0 AS 'Computer Name' , SCU . SystemConsoleUser0 as 'User' , S . SiteName as 'SMS Site Name' , SEU . SerialNumber0 AS 'Serial Number' , SEU . SMBIOSAssetTag0 AS 'Asset Tag' , CS . Manufacturer0 AS 'Manufacturer' , CS . Model0 AS 'Model' , SCU . NumberOfConsoleLogons0 AS 'Console... Read More...
by Garth Jones
Filed under: , , , , , ,
Server by Collection
Friday, May 06, 2011 8:10 AM
select Distinct CS . Name0 , CS . Domain0 , OS . Caption0 From dbo . v_GS_COMPUTER_SYSTEM CS join dbo . v_GS_OPERATING_SYSTEM OS on CS . ResourceID = OS . ResourceID join dbo . v_GS_SYSTEM S on CS . ResourceID = S . ResourceID join dbo . v_FullCollectionMembership FCM on CS . ResourceID = FCM . ResourceID Where S . SystemRole0 = 'Server' and FCM . CollectionID... Read More...
by Garth Jones
Filed under: , , , ,
Canadian Microsoft Management Summit 2011
Monday, May 02, 2011 8:58 AM
Did you miss MMS this year? Well here is you change to see the highlight! (aka Put your head in the cloud)   When: Friday, May 6 Where: Microsoft Canada Headquarters in Mississauga, Ontario Registration Details: http://www.microsoft.com/canada/events/event_details.aspx?event_id=1032484234 Read More...
by Garth Jones
Filed under: , , , , , , , , , , , , , ,
Talk TechNet: take a ways
Friday, April 22, 2011 2:29 PM
As promised here are a few good resource to help you with ConfigMgr. ConfigMgr focused websites http://www.myitforum.com/ http://faqshop.com/ Mailing list http://www.myitforum.com/absolutenm/EmailLists.aspx Forums http://faqshop.com/forums/ http://www.myitforum.com/forums/ http://social.technet.microsoft.com/Forums/en-ca/category/configurationmanager Blogs http... Read More...
by Garth Jones
Filed under: , , , ,
Automatically Submitting Asset Intelligence data
Saturday, March 26, 2011 11:29 PM
I have had few conservation with MS about the AI catalog recently about,  What I’m using it for, why is it important, how the catalog is update and when, etc… Here is what you need to know. MS requires 4 different site to upload an application before it will be categories It takes 30 days for MS for categories an application It takes a farther 90 days before... Read More...
by Garth Jones
Filed under: , , , ,
More Posts Next page »
Go

This Blog

Syndication