vondarius

I need to build a report that shows only laptops, but includes machine name, primary user, subnet, laptop model, and all add/remove programs listings for each respective machine. Is this possible? Has anyone already created such a report?

Nick

That report would require at least two levels.

The first level would list everything but software. The second level drilldown would show you a list of software for the system you selected in level 1.

You may want to take a look at the "Count of Computers by Form Factor" as a start.

__________________
Scire potentia est (knowledge is power)

vondarius

Thanks for the prompt reply Nick. Is it possible to have all this displayed in a single result report vs. choosing machines individually?

Nick

It may be possible but it wouldn't be pretty. It would look something like

computer1 software1
computer1 software2
computer1 software3
computer2 software1
computer2 software2
computer2 software3

Is there a reason you need all laptops with all the software each has? When I have been asked for a report like this in the past I would do a bit more digging and find that the requestor was looking for specific criteria. It would be much easier to generate a report of laptops that have a specific application or applications rather than a list of laptops with all the software on each... not to mention it would be a REALLY long report.

__________________
Scire potentia est (knowledge is power)

vondarius

Yeah, I know it won't be aesthically pleasing, but you know how these manager types are about custom reports. He wants to use such a report to get a bird's eye view of the Laptop machines and their associated apps for an upcoming hardware refresh for our Regional office users. I'm currently able to do a report that resembles what you have above, but I don't know how to add subnet, and model type.

"SELECT
T0.[Name] AS 'Name',
T0.[Domain] AS 'Domain',
T2.[User] AS 'Primary User',
T2.[Month] AS 'Primary User Month',
T1.[Name] AS 'App Name',
T1.[Version] AS 'Product Ver'
FROM [Inv_AeX_AC_Identification] T0 LEFT OUTER JOIN [Inv_AeX_OS_Add_Remove_Programs] T1 ON T0.[_ResourceGuid] = T1.[_ResourceGuid] INNER JOIN [Inv_AeX_AC_Primary_User] T2 ON T0.[_ResourceGuid] = T2.[_ResourceGuid]
WHERE T2.[Month] = 'November'
AND T0.[_ResourceGuid] in (
Select ResourceGuid
From CollectionMembership
Where CollectionGuid = '%Collection%'
)
AND NOT T1.[Name] LIKE 'security update%'
AND NOT T1.[Name] LIKE '%hotfix%'
AND NOT T1.[Name] LIKE 'Altiris%'
AND NOT T1.[Name] LIKE 'Update for%'
AND NOT T1.[Name] LIKE 'Adobe Download%'
AND NOT T1.[Name] LIKE 'Adobe SVG%'
order by T0.[Name], T1.[Name]"

Bear in mind someone did this one for me. I am a NOOB.

Nick

"SELECT
T0.[Name] AS 'Name',
T0.[Domain] AS 'Domain',
T3.[Subnet] AS 'Subnet',
T2.[User] AS 'Primary User',
T2.[Month] AS 'Primary User Month',
T1.[Name] AS 'App Name',
T1.[Version] AS 'Product Ver'
FROM
[Inv_AeX_AC_Identification] T0 LEFT OUTER JOIN [Inv_AeX_OS_Add_Remove_Programs] T1 ON T0.[_ResourceGuid] = T1.[_ResourceGuid]
INNER JOIN [Inv_AeX_AC_Primary_User] T2 ON T0.[_ResourceGuid] = T2.[_ResourceGuid]
INNER JOIN [Inv_AeX_AC_TCPIP] T3 ON T0.[_ResourceGuid] = T3.[_ResourceGuid]
WHERE T2.[Month] = 'November'
AND T0.[_ResourceGuid] in (
Select ResourceGuid
From CollectionMembership
Where CollectionGuid = '%Collection%'
)
AND NOT T1.[Name] LIKE 'security update%'
AND NOT T1.[Name] LIKE '%hotfix%'
AND NOT T1.[Name] LIKE 'Altiris%'
AND NOT T1.[Name] LIKE 'Update for%'
AND NOT T1.[Name] LIKE 'Adobe Download%'
AND NOT T1.[Name] LIKE 'Adobe SVG%'
order by T0.[Name], T1.[Name]"

That will add subnet for you. I didn't look into which table has the system type.

__________________
Scire potentia est (knowledge is power)

vondarius

Dude, you are the man, thx. a bunch. The system type can be found in INV_AEX_HW_Serial_Number.