5 Replies Latest reply on Jan 13, 2017 1:55 AM by phoffmann

    Export Computer record from database to SCN with out Data Analytics

    dgaines Apprentice

      Is there a way to export a computer's client record to an SCN file with out database doctor / Data analytics.  The core is a 2016.3 system.

        • 1. Re: Export Computer record from database to SCN with out Data Analytics
          masterpetz ITSMMVPGroup

          Hi,

           

          unfortunately there is no export feature or function in LDMS like in Data Analytics Database Doctor...sorry.

           

          Regards

          Christian

          • 2. Re: Export Computer record from database to SCN with out Data Analytics
            phoffmann SupportEmployee

            What Christian said.

             

            Essentially - the data analytics DB doctor "scan export" *is* the way to do it.

             

            If you share what you're trying to accomplish, maybe we can offer up alternative methods for you to get what you need?

            • 3. Re: Export Computer record from database to SCN with out Data Analytics
              MarXtar ITSMMVPGroup

              Each client has a full scan file held locally by default. This is the invdelta.dat file found here: C:\Program Files (x86)\LANDesk\LDClient\Data

               

              If you can get to that you have the file already.

               

              Alternatively you can use the scanner with /O= to output a file (again locally) or you could even turn on store scans on the server.

               

              As phoffmann asks though, what are you trying to achieve? This is a multi-skinnable cat so knowing the requirement helps identify the best solution.

               

               

              Mark McGinn

              MarXtar Ltd/MarXtar Corporation

              http://landeskone.marxtar.co.uk

              LANDESK One Development Partner

               

              Try MarXtar State Management for LANDESK to Better Understand and Manage your Assets

              • 4. Re: Export Computer record from database to SCN with out Data Analytics
                dgaines Apprentice

                I am needing to decommission a core, but management doesn't want to loose the inventory data from the few machines that are still on it.   I was looking for a way to export the inventory file for these machines and put them on the new production core.

                • 5. Re: Export Computer record from database to SCN with out Data Analytics
                  phoffmann SupportEmployee

                  I take from your comments then that those devices either no longer exist and/or there's no other way for you to get / generate output SCN's for them then.

                   

                  If you don't have the SCN-files archived yourself in that scenario, that'll be difficult.

                   

                  What you COULD try and do is prehaps ask for help here as a one-off favour / (or paid for service) from your relevant LANDesk ESP (Expert Solution Provider) ... since they should be able to do that for you with the following items:

                  • A copy of the relevant database
                  • A list of devices that need to be exported.

                   

                  They should be able to import the DB into their respective labs & do what you need. This isn't a service that support can provide, but - potentially - LANDesk Pro Services might.

                   

                  In this particular situation, since you don't have the relevant SCN files backed up or can get ahold of them in another way, that's pretty much the only way I see doing this, shy of you writing your own SCN-file generator / extractor.

                   

                  If you "just" need a subset of data, you could create a report / column view for those devices & export that as a CSV / XLS or whatever potentially ... depends on how much data you're after.

                   

                  Hope that helps.