...your virtual communITy
Browse by Tags
Planning, Deploying and Managing Microsoft Systems Center Configuration Manager 2007 (6451a) in Ottawa
If you are looking to take this course, I have been told that CTE Solutions will be running 6451a course the week of Dec 14th - 18th 2009. http://www.ctesolutions.com/course/Systems-Center-Training/Systems-Center-Configuration-Manager-2007-Training.htm?l=ottawa%2Dtraining%2Dfacility&checkout ...
ConfigMgr and OpsMgr Exam Discounts
Are you looking to become certified on ConfigMgr 2007 (70-401) or OpsMgr 2007 (70-400)? Well you are in Luck! Prometric is offering a 20% discount on both exam! http://www.prometric.com/Microsoft/CareerOffer.htm#vouchers20 So what are you waiting for?
List of all machines used by users in a certain AD group
select distinct R.Name, SCU.TopConsoleUser from SMS_R_System R inner join SMS_G_System_SYSTEM_CONSOLE_USAGE SCU on SCU.ResourceID = R.ResourceId where SCU.TopConsoleUser in ( select U.UniqueUserName from SMS_R_User U ...
Attribute Reference Query
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, ...
How to Perform a Basic Software Audit (Query)
Quick follow up to How to Perform a Basic Software Audit Do you want to know how many ARP entries you have? How many page of paper you will get if you print all of the entries? What about bundles of paper? Use this query to help you determine this for you. declare @ARP BIGINT Set @ARP ...
What Virtual Labs, Labcasts, and Webcasts are there to help you with Preparing for Microsoft System Center Configuration Manager 2007 Exam (70-401)
Based on the Microsoft Skills Measured web page for 70-401 , here is a list of items that can help you with your studying for the exam. Deploying a System Center Configuration Manager 2007 (SCCM) Server (9 percent) · Set up and configure an Active Directory schema. · Migrate from an SMS 2003 hierarchy...
How to Perform a Basic Software Audit
Over on the Enhansoft Blog, we posted a blog on “ How to Perform a Basic Software Audit ”. This should help answer the question of how to perform a basic software Audit and why “I need a report of all software for all PCs” is a bad idea.
List Collections a PC belongs to
select FCM.CollectionId, C.Name from dbo.v_R_System r join dbo.v_FullCollectionMembership FCM on R.ResourceID = FCM.ResourceID join dbo.v_Collection C on C.CollectionID = FCM.CollectionID Where R.Name0 = 'ES-03'
Page 15 of 15 (148 items)