Use Full SQL Tables / Views

by

UseFull SQL Tables/ Views Description / Use v_Add_Remove_Programs   v_Advertisement   v_AdvertisementInfo   v_ClientCollectionMembers   v_Collection   v_Collection   v_ConfigurationItems   v_DistributionPoint   v_DistributionPointGroup   v_GS_ADD_REMOVE_PROGRAMS   v_GS_ADD_REMOVE_PROGRAMS_64   v_GS_COMPUTER_SYSTEM   v_GS_DISK   v_GS_Memory_Details0   v_GS_OPERATING_SYSTEM   v_GS_PATCHSTATE   v_GS_SERVICE   v_GS_SoftwareProduct   v_GS_SYSTEM   v_GS_WORKSTATION_STATUS   v_GS_X86_PC_MEMORY   v_OS_Details   v_Package   v_PackageStatus   … Read more

Download these next path ::

by

vnexthttps://www.microsoft.com/downloads/en/details.aspx?FamilyID=ffca869c-4a83-434e-acc9-8b2388c0c7f7&displaylang=en&hash=AsfGo9XDkf9sIbtk88J1avBWmhXUWCuAjSQj1%2fsZM8VWG9dUPmqIq8n7VvOTw8xKAUCheBh89IzMW23MsS5aCA scom r2https://download.microsoft.com/download/E/2/9/E29F1A2F-78B0-4B11-9517-435A2627A72F/OPSMGR2007R2EVAL.exe service managerhttps://download.microsoft.com/download/8/5/2/8529ED85-8D64-4662-A337-2DCA431C495B/SCSM_RETAIL.exe Data Protection Manager https://www.microsoft.com/downloads/en/details.aspx?FamilyID=cba30567-6ef0-4450-93f8-e433897cb093&displaylang=en&hash=S%2flpPNEVndZjpiujZaCC95kn7ehGeZtOLb%2blWlPPZslSlU3mjHyQXFym%2bnRtExHr0cG3eGeGlmGrsaaDapy%2bjw%3d%3d https://www.microsoft.com/downloads/en/details.aspx?FamilyID=cba30567-6ef0-4450-93f8-e433897cb093&displaylang=en&hash=S%2flpPNEVndZjpiujZaCC95kn7ehGeZtOLb%2blWlPPZslSlU3mjHyQXFym%2bnRtExHr0cG3eGeGlmGrsaaDapy%2bjw%3d%3d https://www.microsoft.com/downloads/en/details.aspx?FamilyID=cba30567-6ef0-4450-93f8-e433897cb093&displaylang=en&hash=S%2flpPNEVndZjpiujZaCC95kn7ehGeZtOLb%2blWlPPZslSlU3mjHyQXFym%2bnRtExHr0cG3eGeGlmGrsaaDapy%2bjw%3d%3d https://www.microsoft.com/downloads/en/details.aspx?FamilyID=cba30567-6ef0-4450-93f8-e433897cb093&displaylang=en&hash=S%2flpPNEVndZjpiujZaCC95kn7ehGeZtOLb%2blWlPPZslSlU3mjHyQXFym%2bnRtExHr0cG3eGeGlmGrsaaDapy%2bjw%3d%3d Opalis https://download.microsoft.com/download/D/F/C/DFC9F061-65A9-44C0-9012-450A7B8697CC/Opalis_180_Day_Evaluation.exe

SCCM R3 Provides

by

The following features are new to Configuration Manager 2007 R3. Power Management: Provides a set of tools that enable the site administrator to configure standard Windows power settings across computers and monitor power consumption and computer activity. Operating System Deployment Improvements: Provides pre-staging of boot images and Windows Imaging Format (.wim) files on new computers … Read more

V.Next: Configuration Manager and Systems Management Server

by

Configuration Manager and Systems Management Server TechNet Virtual Lab: Deploying System Center Configuration Manager v.Next TechNet Virtual Lab: Maintaining Healthy Clients in System Center Configuration Manager v.Next TechNet Virtual Lab: Introduction to System Center Configuration Manager v.Next TechNet Virtual Lab: Implementing Settings Management in System Center Configuration Manager v.Next TechNet Virtual Lab: Implementing Role-Based Administration … Read more

Last hardware inventory 14 days

by

———————————————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_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Name not in (select SMS_R_System.Name from SMS_R_System inner join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_WORKSTATION_STATUS.LastHardwareScan >= DateAdd(dd,-14,GetDate()) )———————–