Client Management Suite

Hello. I would like to accurately track where all the licenses are for our business systems.

Ideally I would like the raw sql code to show me this data,

Pc name, User, OS Name, system type, is managed, agent install date.

Im aware that i can retrieve this info from the following locations, but i cant produce reports or export to excel, ive also found the data returned to be misleading.

I know that in the manage > computers > all computers

i can set managed to 1

Manage > filters > Software Filters > Agent and Plug-in Filters

All computers with installed Software Management Plug-in

Please assist, thanks.

I included the primary user, rather than logged on user, because I'm guessing that's what you'd want.  I also don't recall where to get the agent installation date, but did grab the creation date.

Hi thanks for the reply this is good thank you, one query about the vc.createddate, i think this is updated when on the agent u click update, and not the client install date.

apart from that is what i was looking for. Thanks again Zac

That's when the Altiris record is created.  Which doesn't necessarily mean that's when the actual agent was installed.  But on short notice, was my best idea.  I suppose its possible to grab the installation date from software inventory, if necessary.  I can't think of any better ideas, but maybe someone else can.