![]() Inner Join v_GS_OPERATING_SYSTEM ON v_GS_OPERATING_SYSTEM.Resourceid=v_R_System.Resourceid ON dbo.v_R_System.ResourceID = dbo.v_FullCollectionMembership.ResourceID WHEN dbo.v_FullCollectionMembership.SiteCode LIKE 'O%' THEN 'UK' WHEN dbo.v_FullCollectionMembership.SiteCode LIKE 'N%' THEN 'UK' WHEN dbo.v_FullCollectionMembership.SiteCode LIKE 'M%' THEN 'SPAIN' WHEN dbo.v_FullCollectionMembership.SiteCode LIKE 'L%' THEN 'PORTUGAL' WHEN dbo.v_FullCollectionMembership.SiteCode LIKE 'K%' THEN 'Italy' WHEN dbo.v_FullCollectionMembership.SiteCode LIKE 'J%' THEN 'France' WHEN dbo.v_FullCollectionMembership.SiteCode LIKE 'I%' THEN 'Germany' WHEN dbo.v_FullCollectionMembership.SiteCode LIKE 'H%' THEN 'Belgium' WHEN dbo.v_FullCollectionMembership.SiteCode LIKE 'G%' THEN 'US' WHEN dbo.v_FullCollectionMembership.SiteCode LIKE 'F%' THEN 'US' WHEN dbo.v_FullCollectionMembership.SiteCode LIKE 'E%' THEN 'HongKong' WHEN dbo.v_FullCollectionMembership.SiteCode LIKE 'D%' THEN 'HongKong' WHEN dbo.v_FullCollectionMembership.SiteCode LIKE 'C%' THEN 'Japan' WHEN dbo.v_FullCollectionMembership.SiteCode LIKE 'B%' THEN 'India' WHEN dbo.v_FullCollectionMembership.SiteCode LIKE 'A%' THEN 'India' V_GS_OPERATING_SYSTEM.CSDVersion0 as 'Service Pack', V_GS_OPERATING_SYSTEM.Caption0 as 'Operating System', ![]() Copy the following SQL query to find the report SCCM SQL Query to Find Out OS Details.įollowing is the SQL query that you can use to find out the operating system, Service Pack, Site Code, and Location of machines in your organization.Right Click on your database CM_XXX and click on ‘New Query’.Open the SQL Server Management Studio (aka SSMS).SCCM ConfigMgr SQL Query to Find Out OS Details with SP Site Code Country details Configuration Manager? You can follow the below steps to create the SQL Query to Find Out OS Details with SP Site Code Country. SCCM SQL Query to Find Out OS Details with SP Site Code Country SCCM Report for Windows 11 Version Count Dashboard.SCCM SQL Query Windows 10 Version Count Dashboard. ![]() SCCM ConfigMgr SQL Query to Find Out OS Details with SP Site Code Country details Configuration Manager ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |