Report (Custom?) for getting clients' display settings

[ItaloDM85]

Is there a way to build a query for retriefing the display information from remote clients (display size, resolution, orientation)?

[Igor Perevozchikov]

You can build any report query of you will open SMP Console -> Manage -> Computers -> required scope of computers is selected, then click on button "mentioned on attached" pic and choose required view or sql table then save it as report

SQL query of this report from pic above
SELECT DISTINCT
[vri1_Computer].[Guid] AS [Guid],
[vri1_Computer].[Name] AS [Name],
[ajs4_vHWDesktopMonitor].[Feature Support] AS [Feature Support],
[ajs4_vHWDesktopMonitor].[Manufacturer] AS [Manufacturer],
[ajs4_vHWDesktopMonitor].[Manufacturing Date] AS [Manufacturing Date],
[ajs4_vHWDesktopMonitor].[Model] AS [Model],
[ajs4_vHWDesktopMonitor].[Monitor Type] AS [Monitor Type],
[ajs4_vHWDesktopMonitor].[Screen Height] AS [Screen Height],
[ajs4_vHWDesktopMonitor].[Screen Width] AS [Screen Width],
[ajs4_vHWDesktopMonitor].[Serial Number] AS [Serial Number],
[ajs4_vHWDesktopMonitor].[Video Input Mode] AS [Video Input Mode]
FROM
[vRM_Computer_Item] AS [vri1_Computer]
LEFT OUTER JOIN ([ScopeMembership] AS [ajs2_ScopeMembership]
LEFT OUTER JOIN [FolderBaseFolder] AS [ajs3_FolderBaseFolder]
ON ([ajs2_ScopeMembership].[ScopeCollectionGuid] = [ajs3_FolderBaseFolder].[FolderGuid]))
ON ([vri1_Computer].[Guid] = [ajs2_ScopeMembership].[ResourceGuid])
LEFT OUTER JOIN [vHWDesktopMonitor] AS [ajs4_vHWDesktopMonitor]
ON ([vri1_Computer].[Guid] = [ajs4_vHWDesktopMonitor].[_ResourceGuid])
WHERE [vri1_Computer].[Guid] IN (

SELECT computer.[Guid] FROM
(
SELECT
[vri1_Computer].[Guid]
FROM
[vRM_Computer_Item] AS [vri1_Computer]
LEFT OUTER JOIN ([ScopeMembership] AS [ajs2_ScopeMembership]
LEFT OUTER JOIN [FolderBaseFolder] AS [ajs3_FolderBaseFolder]
ON ([ajs2_ScopeMembership].[ScopeCollectionGuid] = [ajs3_FolderBaseFolder].[FolderGuid]))
ON ([vri1_Computer].[Guid] = [ajs2_ScopeMembership].[ResourceGuid])
WHERE
(
(
([ajs3_FolderBaseFolder].[ParentFolderGuid] = '91c68fcb-1822-e793-b59c-2684e99a64cd')
)
)

) AS computer
INNER JOIN fnGetTrusteeScopedResourcesByType('493435f7-3b17-4c4c-b07f-c23e7ab7781f','%TrusteeScope%',1) AS [fnGTSR_3] ON computer.[Guid] = [fnGTSR_3].[ResourceGuid]
INNER JOIN vComputer AS [vCMP_4] ON computer.[Guid] = [vCMP_4].[Guid]

)
GROUP BY
[ajs4_vHWDesktopMonitor].[Monitor Type],
[ajs4_vHWDesktopMonitor].[Screen Height],
[ajs4_vHWDesktopMonitor].[Screen Width],
[ajs4_vHWDesktopMonitor].[Video Input Mode],
[ajs4_vHWDesktopMonitor].[Serial Number],
[ajs4_vHWDesktopMonitor].[Manufacturing Date],
[ajs4_vHWDesktopMonitor].[Feature Support],
[ajs4_vHWDesktopMonitor].[Manufacturer],
[ajs4_vHWDesktopMonitor].[Model],
[vri1_Computer].[Guid],
[vri1_Computer].[Name]
ORDER BY
[Monitor Type],
[Screen Height],
[Screen Width],
[Video Input Mode],
[Serial Number],
[Manufacturing Date],
[Feature Support],
[Manufacturer],
[Model]

------------------------------
Software QA Engineer
Broadcom Inc.
------------------------------

[Shawn Mayhew]

Another version is also adding the video card 

select top 100
ac.name,
convert(varchar, ac.[client date], 101) as 'HeartBeat',
ac.[Hardware Serial Number],
ac.[OS Name],
i.IsManaged,
i.[System Type],
vid.[Device ID],
vid.[Video Processor],
vidcontrol.[Installed Display Drivers],
mon.[Monitor Type],
mon.[Manufacturing Date],
isnull(Mon.[Model], 'Unknown') as 'Model',
mon.[Serial Number],
mon.[Feature Support]
FROM dbo.Inv_AeX_AC_Identification ac
left JOIN vcomputer i ON i.Guid = ac._ResourceGuid
left join dbo.Inv_HW_Display_Controller vid on vid._resourceguid =ac._resourceguid
left join dbo.Inv_HW_Desktop_Monitor mon on mon._ResourceGuid = ac._ResourceGuid
left join dbo.Inv_HW_Video_Controller_Windows vidcontrol
on vidcontrol._ResourceGuid = ac._ResourceGuid
and vidcontrol.[device id] = vid.[Device ID]


------------------------------
Altiris Admin since 2002
------------------------------