santosraymond

Hi everyone,

Just wondering if I could get some help getting some reports created using Altiris. I've never done this before and not sure where or how to start it from the web interface. I've been asked to create a report displaying the user name, host name and ip address of machines that have the following software installed:

IDM Desktop 3.1
IDM Viewer 3.1
Workforce Desktop 5.02a
Visual Workflow Power Libraries
Report Manager 3.4

Also, my access to the Altiris server is limited and I am getting the person who gives rights to give me some rights to create these reports.

Anyway, I'm a little bit confused on what to do, should I create collections first or should I just go to the reports and create a custom report for this ?

Thanks in advance for any help you can provide.

Raymond

Tom.Reyntjens

If you want to report, there is no need to create collections first.
Please be more specific on what you actually want : a report on machines with all these sofwares installed or a report on machines with at least one of these softwares installed.

__________________
Tom

santosraymond

Sorry Tom. I need a report with all the machines that have these software installed. I finally got access to create reports on the report tab. One thing that my administrator could not figure out is that he was able to give me access to create new reports and edit reports but for some reason, he couldn't give me access to delete them. Anyhow, I'm going to try and work on the report builder wizard for now. Thanks for the response.

santosraymond

I think I figured it out, I used the Wizard to generate the report. I used something like this for IDM Desktop 3.1:

SELECT T1.[IP Address] AS 'IP Address', T0.[Name] AS 'Name', COUNT(*) AS 'Number' FROM ( [vResourceEx] T0 INNER JOIN [Inv_AeX_AC_TCPIP] T1 ON T0.[Guid] = T1.[_ResourceGuid] ) INNER JOIN [Inv_AeX_SW_Audit_Software] T2 ON T1.[_ResourceGuid] = T2.[_ResourceGuid] WHERE T2.[ProductName] = 'IDM Configure Application' AND T0.[ResourceTypeGuid] = '493435f7-3b17-4c4c-b07f-c23e7ab7781f' GROUP BY T1.[IP Address], T0.[Name]

Basically I noticed that the report was showing duplicate entries when I added the user names, I removed the user names from the query to show distinct machines. We're just getting ready to upgrade the application and needed to make a count of who's got who and where.

Frogger1

Hi, still not getting anywhere with this. Have done some research and basically in the All Computers Collections some of the Computers do not have Basic Inventroy Information in the AeX AC TCPIP table. How can i figure out why this information is not being populated. Also the SQL table has duplicate entries, these were PC's that were rebuilt and have been given a new name.

I did manage to deploy to a PC that did not have this information so am confused as to why the apps are not installing on some of the PC's. I need to do some deployments to all the machines next week and need to know that this system is going to work.

Also is there a good book that you could suggest that would help understand this beast of a thing.

Thanks

andykn

To track down problems like this you need to look at things in order one one affected machine.

Go to the machine and see if basic Inventory is being generated. Is there an AeX AC TCPIP file? If so what does it contain. If that's all OK use the Agent to force a send of basic inventory. Look at the Server log. Does the file get rejected into one of the Bad directories? Does Resource Explorer for the machine show that Invenotory as being received? Does the AeX TCP/IP info show now?

n_aaron

Here is a query I've used to create a collection that will show me computers by name that have X software installed. Keep in mind that this query will not translate directly to a report query, because the altiris app inserts a conversion layer between you and the SQL you need to get the data ().

To create the report, you need to discover how the software is reporting itself to Altiris, and then set your reporting parameter accordingly. You will probably need 1 report or collection per application you are looking for, to keep things simple.

Anyway, here's the query I've used to create a collection based on the presence of an application on the computer. The bolded portions are where you need to modify it to fit your environment. If I recall correctly, the GUID should be the GUID for "all computers."

Create a clone of the "all computers" collection, and modify the query like below to include a search for the software.

************************

SELECT DISTINCT
d.[Domain],
d.[Name],
a1.[Manufacturer],
a1.[ProductName],
a1.[ProductVersion]
FROM dbo.Inv_AeX_SW_Audit_Software a1
JOIN dbo.Inv_AeX_AC_Identification d
ON a1._ResourceGuid = d.[_ResourceGuid]
LEFT JOIN dbo.CollectionMembership cm
ON cm.ResourceGuid = d.[_ResourceGuid]
LEFT JOIN dbo.vCollection it
ON it.Guid = cm.CollectionGuid
WHERE 1 = 1
AND lower(d.[Domain]) like lower('%Domain%')
AND lower(d.[Name]) like lower('%Computer name%')
AND it.[Guid] LIKE
(CASE
WHEN REPLACE(REPLACE('%Collection%','{',''),'}','') = '200694C3-9D8A-4db6-8D19-68590D1AAA75' THEN '%'
ELSE REPLACE(REPLACE('%Collection%','{',''),'}','')
END)
AND a1._ResourceGuid like '%Resource guid%'
AND (a1.Manufacturer = 'Faronics Corporation')
ORDER BY
d.[Domain],
d.[Name],
a1.[Manufacturer],
a1.[ProductName],
a1.[ProductVersion]

Frogger1

Hi Andy

Thanks for the advice, i've looked on my virtual PC and dont seem to have AeX AC TCPIP.nsi file, only have the *.bak file. I've already tried sending the basic inventory through the Agent last week and that did not update the Resource Explorer.

Thanks