Отображает полную информацию о компьютерах и сетевых параметрах, имени пользователя.0/ConfigMgr_CM1/{5C6358F2-4BB6-4a1b-A16E-8D96795D8602}Noneae566b0f-5bf6-4317-a8b8-2edd52794918AutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_=Parameters!UserTokenSIDs.Valueselect dbo.fn_rbac_GetAdminIDsfromUserSIDs(@UserTokenSIDs) as UserSIDsUserSIDsSystem.StringAutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_SELECT count(*) as CountOS,
case
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Workstation 6.1' Then 'Windows 7'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Workstation 6.1 (Tablet Edition)' Then 'Windows 7'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Workstation 6.0' Then 'Windows Vista'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Workstation 5.1' Then 'Windows XP'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Workstation 6.2' Then 'Windows 8.1'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Server 6.2' Then 'Windows Server'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Advanced Server 6.1' Then 'Windows Server'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Server 6.1' Then 'Windows Server'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Server 5.2' Then 'Windows Server'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Workstation 6.3 (Tablet Edition)' Then 'Windows 8.1'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Workstation 6.3' Then 'Windows 8.1'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Workstation 10.0%' Then 'Windows10'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Server 5.0' Then 'Windows Server'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Server 6.2' Then 'Windows Server'
ELSE 'Other OS'
end as C054
FROM v_R_System SYS
where Last_Logon_Timestamp0 between getdate()-30 and getdate()
Group by Operating_System_Name_and0trueCountOSSystem.Int32C054System.StringAutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_StoredProcedure_sp_RS_CaseOS_SCCM_by_MonthtruefmdSystem.DateTimecssSystem.Int32ymSystem.StringmdSystem.Int32ydSystem.Int32CaseOSSystem.StringAutoGen__5C6358F2_4BB6_4a1b_A16E_8D96795D8602_SELECT COUNT(*) AS 'Count',
case
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Workstation 6.1%' Then 'Windows 7'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Workstation 6.0' Then 'Windows Vista'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Workstation 5.1' Then 'Windows XP'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Workstation 6.2' Then 'Windows 8'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Workstation 10.%' Then 'Windows10'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Server 6.2' Then 'Windows Server 2012'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Advanced Server 6.1' Then 'Windows Server 2008 R2'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Server 6.1' Then 'Windows Server 2008 R2'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Server 5.2' Then 'Windows Server 2003'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Workstation 6.3%' Then 'Windows 8.1'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Server 5.0' Then 'Windows Server 2000'
when SYS.Operating_System_Name_and0 like 'Microsoft Windows NT Server 6.2' Then 'Windows Server Advanced 2012'
ELSE 'Other OS'
end as C054
FROM v_R_System SYS
where Last_Logon_Timestamp0 between getdate()-30 and getdate()
GROUP BY SYS.Operating_System_Name_and0
ORDER BY C054trueCountSystem.Int32C054System.String1.67313in0.25intruetrueCountTextbox25#7082702pt2pt2pt2pt0.25intruetrue=Sum(Fields!Count.Value)Count2pt2pt2pt2pt0.25intruetrue=Sum(Fields!Count.Value)Textbox29#5886582pt2pt2pt2pt9.42813intruetrueC054Textbox30#7082702pt2pt2pt2pt=Fields!C054.Value=Fields!C054.Value9.42813intruetrue=Fields!C054.ValueC054#66a0682pt2pt2pt2pt9.42813intruetrueИтогоTextbox32#5886582pt2pt2pt2ptBeforetrueDataSet39.70083in0.21in0.75in11.10126in=Fields!ym.Value=Fields!yd.Value=Fields!md.Value=Fields!CaseOS.Value=Fields!CaseOS.Value=Sum(Fields!css.Value)truetrue#VALYAutoOutputLinePrimaryPrimaryBlack0pt