5 Replies Latest reply on Feb 10, 2014 12:32 PM by Andrew.Walling

    Inventory of all printers attached to a workstation or / and an user

    Rookie

      Hi everybody and thaks for all the help you provide

       

      I would like to inventory all the printers attached to a workstation or / and a user

       

      Could you help me

      I don't find the way to do that easily.

       

      Thanks a lot

       

      Fab

        • 1. Re: Inventory of all printers attached to a workstation or / and an user
          Apprentice

          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.

          • 2. Re: Inventory of all printers attached to a workstation or / and an user
            Rookie

            For me it's the same thing we want to migrate to Windows 7 and want also to manage the printers 

            • 3. Re: Inventory of all printers attached to a workstation or / and an user
              Rookie

              Hi Sundiata

               

              Have you made progress for this task ?

               

              Fabien

              • 4. Re: Inventory of all printers attached to a workstation or / and an user
                Apprentice

                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.

                 

                First

                ---------

                select distinct name, COUNT(name) as "Number"
                from Printer
                      where (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')
                      group by Name
                      order by Number desc

                 

                 

                Second

                --------

                 

                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

                • 5. Re: Inventory of all printers attached to a workstation or / and an user
                  Rookie

                  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.