![]() ![]() ![]() ![]() Order By SD.Name0 SQL Query To See When Collections Were Last Updated Where VC.Name0 ‘ConfigMgr Remote Control Driver’ Join v_Gs_Video_Controller VC on SD.ResourceID = VC.ResourceID This SQL query will gather video card memory information in Megabytes (Mb) for the machines in your database.Ĭonvert(VarChar, VC.AdapterRam0 / 1024) + ‘ MB’ Order By ‘Machine Name’ SQL Query To Gather Video Card Memory Information Join v_GS_Operating_System OS on SD.ResourceID = OS.ResourceID Join v_RA_System_SmsAssignedSites SC on SD.ResourceID = SC.ResourceID This SQL Query will allow you to list the assigned site code and client version numbers for your advanced client resources. SQL Query To Retrieve Advanced Clients Assigned Site Code And Client Version
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |