→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
omendata
Engaged Sweeper
This would be an essential report if we were to purchase this software.

It appears as though you can only view each computer one by one and there is no way
of creating a customised report for all systems or all servers or all workstations.

Or is there a way as you can do it with SCCM through powershell?

5 REPLIES 5
Hemoco
Lansweeper Alumni
See page 28 in the documentation.

After creating a report you can add it to one of the dashboards.
omendata
Engaged Sweeper
Ok but how do you add the report to the main interface - the manual doesnt tell you?


Hemoco
Lansweeper Alumni
Hi,

Please take a look at http://www.lansweeper.com/documentation.pdf
It contains step by step instructions on how to create reports.

If you need any special reports you can request them in the forum.
omendata
Engaged Sweeper
I presume this is sql?
I have no experience with Sql but have run the script in Sql Studio

Msg 28102, Level 16, State 1, Line 2
Batch execution is terminated because of debugger request.
Msg 208, Level 16, State 1, Line 2
Invalid object name 'tblComputers'.
Query was cancelled by user.

Not exactly great for beginners!

Your product would be much better if you could do this with a gui - most users wouldnt know how to program this.

I haver no experience with SQL although I used to be a systems programmer and would hate to have to write stuff like this just to do a simple task.

Major failing of Lansweepr I think.

You need a gui reporting front end to customise reports.
Hemoco
Lansweeper Alumni
You can create a custom report for this.

This is an example without any special formatting

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblDiskdrives.Caption, tblDiskdrives.Freespace,
tblDiskdrives.Size
From tblComputers Inner Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Where tblDiskdrives.Size Is Not Null