6 Replies Latest reply on Apr 28, 2010 7:42 AM by Henrik.Heves

    Export inventory data

    Henrik.Heves Apprentice

      Hi Guys,


      Pls, help. How can i export a full inventory data of the selected computer or computers?


      Thanks for the help!

        • 1. Re: Export inventory data
          phoffmann SupportEmployee

          You can't - not easily.


          What exactly are you trying to do / what's the end-result of what you want to achieve? And what version of LANDesk are you using?


          There's a variety of reports you can do, a variety of bits of data you can pull out of the database (assuming you have a SQL resource) ... but it all depends.


          If you're just after a text-file with information on what a device has, you can just create an output-scan file on the relevant devices.


          Really all depends on what exactly you're trying to do, ultimately.


          So, if you explain a bit more, we can help a bit better.


          - Paul Hoffmann

          LANDesk EMEA Technical Lead

          • 2. Re: Export inventory data
            Henrik.Heves Apprentice

            Hello Paul,


            Thanks for your answer!


            The exported client inventory is necessery for third party asset management program in xls or xml format. I'm using LDMS9.

            As you mentioned i exactly need a full inventory data same like the *.scn file. We will figure out what we need from the inventory till then i need to present an full innventory data in the xls or xml format.


            I hope you can help better now.


            Many thanks for your support!

            • 3. Re: Export inventory data
              phoffmann SupportEmployee

              Well - we don't have a way to export inventory into XML format.


              I think you'll be best off working through an output-file and scripting a "migration tool" from an SCN file to your desired XML file.


              To that end, you probably will want to look very closely at a scan file and see what data you actually need.


              So the easy thing to do is to generate the output file. You can do this by starting with the "basic" inventory scan command-line you have in a startup group, which would be something like this (I've made it a bit more generic):


              "C:\Program Files\LANDesk\LDClient\LDISCN32.EXE" /NTT=THECORE:5007 /S=THECORE  /I=HTTP://THECORE/ldlogon/ldappl3.ldz /V


              Then you add a few command line switch as follows:


              "/O=Location\filename" -- creates an output scan

              "/F" -- forces a software scan, if you want to include software.

              "/SAE" -- forces "send all executed", which is related to software license monitoring

              "/PD" -- forces to include "product definitions" (not too useful for an XML I think, but never know).


              So you could end up with something like:


              "C:\Program Files\LANDesk\LDClient\LDISCN32.EXE" /NTT=THECORE:5007  /S=THECORE  /I=HTTP://THECORE/ldlogon/ldappl3.ldz /V /F /SYNC /SAE /PD /O=C:\output.scn



              ==> which would write the file "OUTPUT.SCN" to the root of C:\.


              You may want to drop the "/V" switch (makes the scanner run in verbose mode and with graphical progress enabled).


              That should get you started I think - more controlled this way, than just gathering scan-files on the Core.


              - Paul Hoffmann

              LANDesk EMEA Technical Lead

              • 4. Re: Export inventory data
                klevitan Specialist

                You might want to look at an add-on application that can do this.  I have had very good success with Managed Planet. www.managedplanet.com


                  - Kurt

                • 5. Re: Export inventory data
                  Henrik.Heves Apprentice

                  Dear Paul,


                  thanks for your answer. I'll try out your solution and let you know the result.


                  Thanks a lot, Henrik

                  • 6. Re: Export inventory data
                    Henrik.Heves Apprentice

                    Hi Kurt,


                    thanks for the idea, i'll check it!