Video Screencast Help
Protect Your POS Environment Against Retail Data Breaches. Learn More.

Report to tie Primary User to Installed Applications

Created: 26 Mar 2012 | 2 comments

Good morning,

While I know that pretty much everything is tied directly to computers (and not USERS) in 6.x, I have a deliverable that requires I output USER and INSTALLED APPLICATION data for an external project. Has anyone done this before? I am looking for any guidance or starting point I can get. I am assuming that we can tie PRIMARY USER to COMPUTER NAME and Applications with some SQL magic, but I am hoping some wizards out there might have some of the insight I am looking for.

I should have all of the requirements sometime this week but it does sound as USER and Installed Applications are going to be what is required. Any thoughts on how to do this or Reports you might already have working would be much appreciated!

 

Thank you.

DC

Comments 2 CommentsJump to latest comment

mclemson's picture

Pretty simple.  This is a computer report of installed software:

SELECT vc.Name, arp.[Name],arp.[Version]
FROM vComputer vc
JOIN Inv_AeX_OS_Add_Remove_Programs arp ON arp._ResourceGuid=vc.[Guid]
WHERE vc.IsManaged=1

If instead you want to report on the primary user, simply replace vc.Name with vc.[User].  In my opinion, reports like these are big, fat messes required by someone who wants to answer questions but has trouble articulating what that question is.  Most managers don't realize that Altiris will inventory several hundred to several thousand "applications" per computer.

Additionally, I'm not in NS6 every day anymore, so you'll want to confirm the table name for arp is correct.

Does this answer your question?

Mike Clemson, Senior Systems Engineer, ASC
Intuitive Technology Group -- Symantec Platinum Partner
intuitivetech.com

HighTower's picture

The table name is correct.  Way to work from the ole' memory.

I agree with Mike.  Someone asks for this report and then will tell you that "too much" is in the spreadsheet that they don't care about.  You'll have a lot of back and forth as to what they're actually trying to get data on.  In the end they're usually looking for software that's licensed or software that shouldn't be installed and wants to task someone to remove it.