For our helpdesk people that need to find the owner of the coputer quickly for remote control purposes, before 7.5 SP1 upgrade there was a way to easily type the primary owner in the filter and the computer would display that they were the primary owner. It seems like this is more of a challenge to figure out under 7.5 SP1.
Here is a query
SELECT
[vri1_Computer].[Guid] AS [GUID]
FROM
[vRM_Computer_Item] AS [vri1_Computer]
LEFT OUTER JOIN [Inv_AeX_AC_Primary_User] AS [dca2_AeX AC Primary User]
ON ([vri1_Computer].[Guid] = [dca2_AeX AC Primary User].[_ResourceGuid])
LEFT OUTER JOIN [vAC_IPAddress] AS [ajs3_vAC_IPAddress]
ON ([vri1_Computer].[Guid] = [ajs3_vAC_IPAddress].[Guid])
INNER JOIN [vAC_ComputerState] AS [ajs4_vAC_ComputerState]
ON ([vri1_Computer].[Guid] = [ajs4_vAC_ComputerState].[Guid])
LEFT OUTER JOIN ([ScopeMembership] AS [ajs5_ScopeMembership]
LEFT OUTER JOIN [FolderBaseFolder] AS [ajs6_FolderBaseFolder]
ON ([ajs5_ScopeMembership].[ScopeCollectionGuid] = [ajs6_FolderBaseFolder].[FolderGuid]))
ON ([vri1_Computer].[Guid] = [ajs5_ScopeMembership].[ResourceGuid])
WHERE
(
(
([ajs6_FolderBaseFolder].[ParentFolderGuid] = N'91c68fcb-1822-e793-b59c-2684e99a64cd')
AND
(LOWER([dca2_AeX AC Primary User].[User]) ='username')
)
)
I need a filter that allows adhoc way of pulling up the primary Owner please. This will only pull up the same user every time.
Thanks.