n00b help - Report - All Computers with Visio Installed

celicasx · 05-17-2009, 11:42 PM

Can someone please help me work out how to run a report where i get a list of computers with Visio installed.

I'm new to reporting.
Thanks

dfrancis · 05-18-2009, 09:14 AM

Try importing this report. You can search by collection for various programs as listed in Add/Remove Programs.

celicasx · 05-18-2009, 07:41 PM

hmmmm, nah i got an error when trying to import.
Could it be versions ?

Was it an easy report to create ?
Possibly if it was, i could have some steps ?

thanks

Mat

mack_jason · 05-18-2009, 09:36 PM

Try this to start with.

Select Distinct
vc.[guid], arp.[Resourceguid], vc.[name] as 'Computer name', vc.[user], arp.[name] as 'Application Name', [Version]
From Vcomputer vc
join inv_aex_os_add_remove_programs arp
on vc.[guid] = inv.[Resourceguid]

you can always find more columns by using

Select * from vcomputer

Select * from inv_aex_os_add_remove_programs

celicasx · 05-18-2009, 09:47 PM

im sorry i dont understand where i am supposed to do that?

Do i need to create a new report ? Simple ? Advanced ?

mack_jason · 05-18-2009, 09:53 PM

I personally don't like the report builder and create 99.9% of my reports from SQL. However, you can create a new report and choose the advanced option which will allow you to enter SQL directly.

If you are new to Altiris or SQL I would suggest looking at the reports form of this site and a book called SQL queries for mere mortals. This book is great and helped me when starting out with SQL.

Amazon.com: SQL Queries for Mere Mortals(R): A Hands-On Guide to Data Manipulation in SQL: Michael J. Hernandez, John L. Viescas: Books

Brandon · 05-19-2009, 07:48 PM

To import that XML first clone, then export one of your canned reports. Open it up and view the version info.

Now edit the attached xml changing this line:
Version=6.0.6074.110 to Version=xxxxxxxxxxxxx
where this matches the same version of your exported clone. There should be two instances, one is a comment.

Now try to import the xml and it will probably work.

celicasx · 05-19-2009, 08:02 PM

Thanks for that advice, i tried it and it got a little furthur.

I now recieve the following error

"Error importing item: Serverwas unable to process request. --> The root element is missing"

That version number WAS different tho, but i had adjusted it.

Brandon · 05-19-2009, 08:09 PM

Well then paste in the entries from that xml or from mack_jason manually.

You are right, go to New > report > enter sql directly > paste.