→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
bastian23
Engaged Sweeper
Hello,

is it possible to create a report with following information

Operating System | Hostname | IP

and in best case for every OS, Windows, Linux, Solaris....


thanks in advance.

br
Sascha
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Non-Windows machines are currently considered "devices" in Lansweeper. We recommend creating a separate report for these using tblCustDevices, as it is currently very difficult to create a report that includes both computers and devices.

In Lansweeper 5.0, which is currently in development, computers and devices will be merged into a single "asset" category, which will simplify the kind of reporting you are trying to do. We expect to have a 5.0 beta release ready by October.

A basic device report can be seen below.
Select Top 1000000 tsysDevicetypes.ItemTypeIcon10 As icon,
tblCustDevices.Displayname As [Device name], tsysDevicetypes.ItemTypename As
[Device Type], tblCustDevices.Model, tblCustDevices.Vendor,
tblCustDevices.Location, tblCustDevices.Ipaddress, tblCustDevices.FirstSeen,
tblCustDevices.LastSeen, tblCustDevices.DeviceKey, tblCustDevHD.Filesystem,
tblCustDevHD.Size, tblCustDevHD.Used, tblCustDevHD.Available
From tblCustDevices Inner Join
tsysDevicetypes On tsysDevicetypes.ItemType = tblCustDevices.Devicetype
Left Join
tblCustDevHD On tblCustDevices.DeviceKey = tblCustDevHD.DeviceKey
Where tblCustDevices.State = 1
Order By tsysDevicetypes.ItemTypename, tblCustDevices.Displayname,
tblCustDevHD.Size Desc

View solution in original post

2 REPLIES 2
Hemoco
Lansweeper Alumni
Non-Windows machines are currently considered "devices" in Lansweeper. We recommend creating a separate report for these using tblCustDevices, as it is currently very difficult to create a report that includes both computers and devices.

In Lansweeper 5.0, which is currently in development, computers and devices will be merged into a single "asset" category, which will simplify the kind of reporting you are trying to do. We expect to have a 5.0 beta release ready by October.

A basic device report can be seen below.
Select Top 1000000 tsysDevicetypes.ItemTypeIcon10 As icon,
tblCustDevices.Displayname As [Device name], tsysDevicetypes.ItemTypename As
[Device Type], tblCustDevices.Model, tblCustDevices.Vendor,
tblCustDevices.Location, tblCustDevices.Ipaddress, tblCustDevices.FirstSeen,
tblCustDevices.LastSeen, tblCustDevices.DeviceKey, tblCustDevHD.Filesystem,
tblCustDevHD.Size, tblCustDevHD.Used, tblCustDevHD.Available
From tblCustDevices Inner Join
tsysDevicetypes On tsysDevicetypes.ItemType = tblCustDevices.Devicetype
Left Join
tblCustDevHD On tblCustDevices.DeviceKey = tblCustDevHD.DeviceKey
Where tblCustDevices.State = 1
Order By tsysDevicetypes.ItemTypename, tblCustDevices.Displayname,
tblCustDevHD.Size Desc
bastian23
Engaged Sweeper
hi,

i found this report:

Name:Server:All servers

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, Web40OSName.OSname, tblOperatingsystem.Description, tblComputersystem.Lastchanged, Web40OSName.Compimage As icon From tblComputersystem Inner Join tblComputers On tblComputersystem.Computername = tblComputers.Computername Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join tblOperatingsystem On tblComputers.Computername = tblOperatingsystem.Computername Where tblComputersystem.Domainrole > 1 Order By dbo.tblComputers.Computer

but with this view, I see only windows server and not my unix/linux/solaris servers.

is it possible to change this?