Query

[Greg Osinski]

Good morning all,

I'm wondering if you could help. I have been asked to create a report in altiris to set up a report that we can run.
The info that Altiris need to gather are following
- list of all assets for specific OU
- last logon stamp
- last logged in user

Tried to find anything on forums ( altiris for newbie) but most of the existing articles are really advance and I need to start from the scratch

Thank you in advance for any replies

[MonitorMan]

Something basic like this?

And what do you mean by 'Last Logon Stamp'? I took it as the last time the managed object 'touched' the SMP.

select 
vc.Name
,vc.[IP Address]
,acid.[Last Logon User]
,acs.LastBasicInventoryUpdate
,axl.[Distinguished Name]
 from 
vComputer vc
join Inv_AeX_AC_Client_Status acs 
on vc.Guid = acs._ResourceGuid and vc.ismanaged = 1
join Inv_AeX_AC_Location axl
on vc.Guid = axl._ResourceGuid
join Inv_AeX_AC_Identification acid
on vc.guid = acid._ResourceGuid
Where axl.[Distinguished Name] like '%,OU=OU,DC=DOMAIN,DC=DOMAIN,DC=DOMAIN'
order by vc.Name