Automate Reports / Command Line options

[rwyarger]

Hello -

We have a set of reports that we are wanting to use to import into a custom database that we are going to use for Asset Tracking (it's very rudimentary, but it works for our need).

Is there any way that I can simply save my reports from any command line options that come with Lansweeper? If not - is it possible for me to somehow automate the reports to run, and then save themselves into the Excel option on a share of my choosing, or even to one of the local drives of the server it is on?

Thank you,

[rwyarger]

Susan, thank you for this information. I will attempt to see if I can somehow automate my process to utilize this, and I will message you our contact info for the 6.0 Beta testing.

[Susan_A · Accepted solution]

Running a report does not trigger a scan of the machines contained within the report. A report only queries what is already in your database. The information stored in your database will only be up-to-date if your machines have recently and successfully been scanned.

Scans are set up through the Lansweeper web console or triggered from your client machines with the LsPush scanning agent. If you are trying to scan machines in specific reports on a scheduled basis, you could do so with Asset Collection Scanning.

Lansweeper 6.0 will allow you to have report results automatically copied to a folder by the way. We're currently in the final stages of internal alpha testing for 6.0. If you haven't already, contact support@lansweeper.com to be added to our list of beta testers. You'll be notified via email as soon as the beta becomes available.

[rwyarger]

Actually - I think I found a better way, but now I need to know something different.

The TSQL is shown for what is grabbing the data to generate a report. What I need to know now is what the command is to perform a scan for that report.

Is there a command line equivalent for scanning the assets of your report (specific to your report) before generating a result set?

[TJa]

Hi,

maybe You could use automation under "Configuration"->"Email Alerts" . You can create scheduled action to generate report and send it as attachment (xls file)

regards
--
Tomasz

[rwyarger]

TJa wrote:
Hi,

maybe You could use automation under "Configuration"->"Email Alerts" . You can create scheduled action to generate report and send it as attachment (xls file)

regards
--
Tomasz

I've done some testing with this today, and it does appear that as changes happen that my report brings data back for - it is updating the tables automatically (without the need for scanning) in the database. If that is true - and works that way for the 3 reports I need to run, then I may not need to scan each time before running the report.

Can anyone confirm this? If you need more specifics (e.g. see the TSQL of the reports I am running to determine the truth of this assumption), please let me know.

Better yet - I have the queries attached.

Thank you