you beat me in posting this today. I am looking to create a query or report of the same thing. We are beginning our Windows7 migration and I'd like to possibly locate any printers that may not be compatible. I can create a query for this and add qualifiers for printers #1-10 but this would be a pain as well as the results view (too many empty columns). I would also like to eliminate printers such as OneNote, Fax, XPS, etc from the results. I assume that this may require an SQL report but I am still learning the basics.
For me it's the same thing we want to migrate to Windows 7 and want also to manage the printers
Have you made progress for this task ?
I have been messing around with SQL and have come up with two queries. The first one gives a printer count of each unique printer name in the database with the exception of the common ones that I added. The second one will give a list of all printers except the common ones that were specified (OneNote, fax, etc). I just do not see a way to accomplish this through the LANDesk interface and I now have to figure out how to get this information correctly into Report Designer. I will definitely let you know if I get anywhere. Maybe someone will be able to provide some better insight on this.
---------select distinct name, COUNT(name) as "Number"from Printerwhere (Name not like '%onenote%' andName not like '%microsoft xps%' andName not like '%pdf%' andName not like '%webex%' andName not like '%smartprint%' andName not like '%paperport%' andName not like '%office live%' andName <> 'fax' andName <> 'Microsoft Office Document Image Writer')group by Nameorder by Number desc
select distinct A2.DeviceName, A0.Name from Printer as A0
join LanDesk A1 on A0.Computer_Idn = A1.Computer_Idn
join Computer A2 on A0.Computer_Idn = A2.Computer_Idn
where A1.ClientConfigurationName = 'employee' and
(Name not like '%onenote%' and
Name not like '%microsoft xps%' and
Name not like '%pdf%' and
Name not like '%webex%' and
Name not like '%smartprint%' and
Name not like '%paperport%' and
Name not like '%office live%' and
Name <> 'fax' and
Name <> 'Microsoft Office Document Image Writer')
order by a0.Name
I've had a similar problem getting and inventory of network connected printers. I thought I might be able to use "Manage Software List" to create a custom "Registry Item" entry. You can get the connections at "\\HKCU\Printers\Connections" and you have sub-keys with the information there. The problem is how can I gather data for an entire subkey. I've tried using wildcards but that doesn't seem to work. Any help would be appreciated.