Computer Type Designation Report

Within the Asset Control piece of Altiris Asset Management Suite there is a Computer Type field which you can select Workstation or Server (under the "Type" tab while creating or editing a Computer asset). We added another designation called "Laptop," but found no reports where this was useful...

Out-of-box in Altiris reports did not allow you to search based upon the Computer Type...just the Asset/Resource Type. So, after a long time of working and re-working we found a way to associate asset information, and make it useful for us.

We needed a way to search all laptop assets, as well as know who was the last person logged on and using it. Below gives us all of that data we needed and more.

Follow the steps below.

1. We created a new report and named it.
2. We gave the new report a description of what the report was used for and what was returned in the report.
3. Created a global parameter for that report.
   
   1. We called 'Computer Type' (see SQL below).
   2. We made this a Dropdown "Parameter type".
   3. We had it prompt the user with a "List type" of Query Results.
   4. The "Value type" of String.
   5. The "Value" entered for the parameter is below. We were specific because we did not want to include the out-of-box "Test" value.
      

      select [Name] as 'Computer Type' from vComputerType where ([Name] = 'Laptop' OR [Name] = 'Server' OR [Name] = 'Workstation')
      
      

4. Then we entered in the SQL query below.

   SQL Query

   Select DISTINCT  
   	vi.[Name], 
   	ID.[Last Logon User], 
   	I.[Name] AS 'Location', 
   	Vct.[Name] AS 'Computer Type', 
   	va.[Serial Number], 
   	va.Model 
   	 
   FROM vResourceItem vi   
   JOIN ResourceAssociation ra  
   	on ra.ParentResourceGuid = vi.Guid   
   --	and ra.ResourceAssociationTypeGuid ='74c9ad4a-e384-477e-bd06-132a3368e58d')    
   left outer join vasset va 
   	on va._ResourceGUID = vi.GUID  
   left outer join dbo.ResourceAssociation loc 
   	ON (loc.ChildResourceGuid = vi.GUID 
   		OR loc.ParentResourceGuid = vi.GUID) 
   		and loc.ResourceAssociationTypeGuid = '05DE450F-39EA-4AAE-8C5F-77817889C27C' 
   left outer join vItem I 
   	on loc.ChildResourceGUID = I.GUID 
   left outer JOIN vComputerType  vct  
   	on vct._ResourceGuid = ra.ChildResourceGuid  
   left outer join Inv_Aex_AC_Identification ID 
   	ON ID._ResourceGUID = va._ResourceGUID 
   
   where vct.[Name] LIKE %Computer Type% 
   
   ORDER BY vi.[Name]