# Altiris SQL
```sql
SELECT
[vri1_Computer].[Guid] AS [GUID]
FROM
[vRM_Computer_Item] AS [vri1_Computer]
LEFT OUTER JOIN [Inv_AeX_AC_Identification] AS [dca2_AeX AC Identification]
ON ([vri1_Computer].[Guid] = [dca2_AeX AC Identification].[_ResourceGuid])
LEFT OUTER JOIN [vAC_AgentCommunicationHealth] AS [ajs3_vAC_AgentCommunicationHealth]
ON ([vri1_Computer].[Guid] = [ajs3_vAC_AgentCommunicationHealth].[ResourceGuid])
WHERE
(
(
(CONVERT(DATE, [ajs3_vAC_AgentCommunicationHealth].[Last Agent Communication]) > CONVERT(DATE, DATEADD(DAY, -30, GETDATE())))
AND
(LOWER([dca2_AeX AC Identification].[OS Version]) LIKE '%' + N'10.0' + '%')
)
)
```
# NEW
```sql
SELECT DISTINCT
[vri1_Computer].[Guid] AS [GUID],
[vri1_Computer].[Name] AS [Name],
[ajs4_vAC_AgentCommunicationHealth].[Last Agent Communication] AS [Last Agent Communication],
[ajs8_vHWChassis].[Manufacturer] AS [Manufacturer],
[ajs8_vHWChassis].[Serial Number] AS [Serial Number],
[ajs5_vAC_IPAddress].[IP Address] AS [IP Address],
[ajs7_vAllComputerInfo].[OS Version] AS [OS Version],
[ajs6_vAC_PrimaryUser].[Primary User] AS [Primary User]
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 [vAC_AgentCommunicationHealth] AS [ajs4_vAC_AgentCommunicationHealth]
ON ([vri1_Computer].[Guid] = [ajs4_vAC_AgentCommunicationHealth].[ResourceGuid])
LEFT OUTER JOIN [vAC_IPAddress] AS [ajs5_vAC_IPAddress]
ON ([vri1_Computer].[Guid] = [ajs5_vAC_IPAddress].[Guid])
LEFT OUTER JOIN [vAC_PrimaryUser] AS [ajs6_vAC_PrimaryUser]
ON ([vri1_Computer].[Guid] = [ajs6_vAC_PrimaryUser].[ResourceGuid])
LEFT OUTER JOIN [vAllComputerInfo] AS [ajs7_vAllComputerInfo]
ON ([vri1_Computer].[Guid] = [ajs7_vAllComputerInfo].[Guid])
LEFT OUTER JOIN [vHWChassis] AS [ajs8_vHWChassis]
ON ([vri1_Computer].[Guid] = [ajs8_vHWChassis].[_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])
LEFT OUTER JOIN [vAC_AgentCommunicationHealth] AS [ajs4_vAC_AgentCommunicationHealth]
ON ([vri1_Computer].[Guid] = [ajs4_vAC_AgentCommunicationHealth].[ResourceGuid])
WHERE
[ajs3_FolderBaseFolder].[ParentFolderGuid] = '91c68fcb-1822-e793-b59c-2684e99a64cd'
AND [ajs4_vAC_AgentCommunicationHealth].[Last Agent Communication] >= DATEADD(DAY, -30, GETDATE())
) 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_vAC_AgentCommunicationHealth].[Last Agent Communication],
[ajs5_vAC_IPAddress].[IP Address],
[ajs6_vAC_PrimaryUser].[Primary User],
[ajs7_vAllComputerInfo].[OS Version],
[ajs8_vHWChassis].[Serial Number],
[ajs8_vHWChassis].[Manufacturer],
[vri1_Computer].[Guid],
[vri1_Computer].[Name]
ORDER BY
[Last Agent Communication],
[IP Address],
[Primary User],
[OS Version],
[Serial Number],
[Manufacturer];
```