Client Management Suite

We have a lots of printer that assign the IP address and printer name using our print server, is anyway I can created the report that has entire printer IP address and printer name.

Where I can collect this information from?

Thanks

Lillian

See below thread

https://www-secure.symantec.com/connect/forums/printer-report

https://www-secure.symantec.com/connect/forums/inventory-connected-network-printers

THis is pretty help,

I found the table in altiris is call "inv_printers", this one has printer name but do not have port, where I can find the printer port table?

Thanks

Lillian

Useful views are vHWPrintersWindows and vHWPrinter.

Marking James007 post as the answer as these post references contain the information required here.

or you could run this report 

select distinct
   ac.name,
   convert(varchar, ac.[client date], 101) as 'ScanDate',
ac.[OS Name] AS 'OS Name',
 ac.[Hardware Serial Number],ac.[OS Name], ac.[System Type],
pri.[Device ID], pri.[Default], pri.[Port Name], pri.[Server Name], pri.[Share Name], 
Prime.[primary user],                                                                                                
t20.[Given Name] as 'First Name',                                                                                                                                        
ISNULL(t20.[Surname],'') AS 'Last Name',                                 
t20.[office telephone],                                                    
t20.department
 

 from
Inv_AeX_AC_Identification ac
left join  inv_hw_printer_windows pri
on pri._ResourceGuid =ac._ResourceGuid

left join vComputer vc on vc.Guid =ac._ResourceGuid 
 
 left join (SELECT     _ResourceGuid, MAX([user]) AS [primary user]  
    FROM         dbo.Inv_AeX_AC_Primary_User   
    WHERE     ([User] IS NOT NULL) AND ([User] <> '') 
    GROUP BY _ResourceGuid  ) Prime                          
    on ac._resourceguid =  Prime._ResourceGuid
LEFT   JOIN (select distinct vuser.*   from  vuser    where [Given Name] !='' )t20 
    ON Prime.[primary user] =   T20.name 

where  
  ac.[Client Date] > GETDATE ()-90
  and pri.[Port Name]is not null
  and pri.[Port Name] not like '%xps%'
  and pri.[Port Name] not like '%onenote%'
  and ac.[OS Name]not like '%server%'
  and pri.[Device ID] not like '%pdf%'
  and pri.[Device ID] not like '%onenote%'
  and pri.[Device ID] not like 'efile%'
  and pri.[Device ID] not like 'webex%'
   and pri.[Device ID] not like 'paper%'
 

order by ac.Name asc, pri.[Device ID] asc