לדעתי ליצור דו"ח חדש עם הערכים שאתה רוצה יהיה פשוט יעיל יותר.
מצ"ב דו"ח חומרה עבור מחשבים לפי Collection עם Primary User (המחשב יופיע בדו"ח רק אם יש לו שיוך למשתמש).
SELECT DISTINCT
dbo.v_R_System.Name0 AS [Computer Name], dbo.v_GS_OPERATING_SYSTEM.Caption0 AS [Operating System],
dbo.v_GS_OPERATING_SYSTEM.CSDVersion0 AS [Service Pack], dbo.v_GS_COMPUTER_SYSTEM.Model0 AS Model,
dbo.v_GS_PC_BIOS.Manufacturer0 AS [Computer Manufacture], dbo.v_R_User.Name0 AS [User Name], dbo.v_R_System.AD_Site_Name0 AS [AD Site],
dbo.v_GS_COMPUTER_SYSTEM.Domain0 AS Domain, dbo.v_GS_PC_BIOS.SerialNumber0 AS [Bios serial], dbo.v_GS_PC_BIOS.ReleaseDate0 AS [Bios Date],
dbo.v_GS_LOGICAL_DISK.Size0 AS [Disk Size], dbo.v_GS_X86_PC_MEMORY.TotalPhysicalMemory0 AS [Total Memory],
dbo.v_GS_PROCESSOR.Name0 AS [CPU Name], dbo.v_GS_PROCESSOR.MaxClockSpeed0 AS [CPU Speed]
FROM dbo.v_R_User INNER JOIN
dbo.v_UsersPrimaryMachines ON dbo.v_R_User.ResourceID = dbo.v_UsersPrimaryMachines.UserResourceID INNER JOIN
dbo.v_R_System ON dbo.v_UsersPrimaryMachines.MachineID = dbo.v_R_System.ResourceID INNER JOIN
dbo.v_GS_COMPUTER_SYSTEM ON dbo.v_R_System.ResourceID = dbo.v_GS_COMPUTER_SYSTEM.ResourceID INNER JOIN
dbo.v_GS_PC_BIOS ON dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_GS_PC_BIOS.ResourceID INNER JOIN
dbo.v_GS_SYSTEM_ENCLOSURE ON dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_GS_SYSTEM_ENCLOSURE.ResourceID INNER JOIN
dbo.v_GS_OPERATING_SYSTEM ON dbo.v_GS_COMPUTER_SYSTEM.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID INNER JOIN
dbo.v_GS_PROCESSOR ON dbo.v_GS_SYSTEM_ENCLOSURE.ResourceID = dbo.v_GS_PROCESSOR.ResourceID INNER JOIN
dbo.v_GS_X86_PC_MEMORY ON dbo.v_GS_PROCESSOR.ResourceID = dbo.v_GS_X86_PC_MEMORY.ResourceID INNER JOIN
dbo.v_GS_LOGICAL_DISK ON dbo.v_GS_PC_BIOS.ResourceID = dbo.v_GS_LOGICAL_DISK.ResourceID
JOIN v_FullCollectionMembership fcm on fcm.resourceid=v_r_system.resourceid
Where fcm.Collectionid= @Collection
להוספת Prompt עבור בחירת Collection יש להוסיף Dataset עם השאילתה הבאה:
select CollectionID, Name from v_Collection Order by Name
שים לב שערך
דיסק יכול ליצור רשומות כפולות בדו"ח אז ניתן להסירו במידת הצורך.
Please take a moment to Vote as Helpful and/or Mark as Answer where applicable. Thanks.
