Still looking for a solution, here.
Here's the copy of the query I used. I don't understand it enough to adjust it, but it does leave me with some questions...
SELECT
[vri1_Computer].[Guid] AS [_ResourceGuid]
FROM
[vRM_Computer_Item] AS [vri1_Computer]
INNER JOIN [Inv_AeX_AC_Identification] AS [dca2_AeX AC Identification]
ON ([vri1_Computer].[Guid] = [dca2_AeX AC Identification].[_ResourceGuid])
INNER JOIN [vComputerResource] AS [ajs3_vComputerResource]
ON ([vri1_Computer].[Guid] = [ajs3_vComputerResource].[Guid])
WHERE
(
(
([vri1_Computer].[IsManaged] = 1)
AND
([vri1_Computer].[ResourceItemDeleted] = 0)
AND
(
([dca2_AeX AC Identification].[OS Name] = N'Microsoft Windows 95')
OR
([dca2_AeX AC Identification].[OS Name] = N'Microsoft Windows 98')
OR
([dca2_AeX AC Identification].[OS Name] = N'Microsoft Windows ME')
OR
(
([dca2_AeX AC Identification].[OS Name] = N'Microsoft Windows NT')
AND
([dca2_AeX AC Identification].[OS Type] = N'Workstation')
)
OR
(
([dca2_AeX AC Identification].[OS Name] = N'Microsoft Windows 2000')
AND
([dca2_AeX AC Identification].[OS Type] = N'Professional')
)
OR
([dca2_AeX AC Identification].[OS Name] LIKE N'Microsoft Windows XP%')
OR
([dca2_AeX AC Identification].[OS Name] LIKE N'%Vista%')
OR
([dca2_AeX AC Identification].[OS Name] LIKE N'%Windows 7%')
OR
([dca2_AeX AC Identification].[OS Name] LIKE N'%Windows 8%')
OR
(LOWER([dca2_AeX AC Identification].[OS Name]) LIKE N'%preinstallation environment%')
)
)
)
1. Could these lines indicate that the query isn't identifying anything without an agent, including the WinPE boot disk?
([vri1_Computer].[IsManaged] = 1)
AND
([vri1_Computer].[ResourceItemDeleted] = 0)
I tried to change the ".[IsManaged]" to = 0 but this didn't help.
2. How can I change the query to give me computer names, so I can at least know what I am looking at?
3. Can someone write me a replacement query? I need all workstations, no servers. It needs to include WinPE machines.
Any help would be appreciated.....
S.....