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

is there a way to query the size of the harddisk?
Everything I've found gives me only the size of the partitions on the disk not the size of the harddisk itself.

Greetings, Stephan
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
You can create a report based on tblFloppy. An example report can be seen below.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblFloppy.Name, tblFloppy.Description,
tblFloppy.Manufacturer, tblFloppy.Model, tblFloppy.InterfaceType,
tblFloppy.bytespersector, tblFloppy.Partitions, tblFloppy.Sectorspertrack,
tblFloppy.Size, tblFloppy.Totalcylinders, tblFloppy.Totalheads,
tblFloppy.Totalsectors, tblFloppy.Totaltracks, tblFloppy.TracksperCylinder
From tblComputers Inner Join
tblFloppy On tblComputers.Computername = tblFloppy.Computername
Order By tblComputers.ComputerUnique, tblFloppy.Name

To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.

View solution in original post

2 REPLIES 2
Nixfaenger
Engaged Sweeper
many thanks, exactly what I wanted

Greetings, Stephan
Hemoco
Lansweeper Alumni
You can create a report based on tblFloppy. An example report can be seen below.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblFloppy.Name, tblFloppy.Description,
tblFloppy.Manufacturer, tblFloppy.Model, tblFloppy.InterfaceType,
tblFloppy.bytespersector, tblFloppy.Partitions, tblFloppy.Sectorspertrack,
tblFloppy.Size, tblFloppy.Totalcylinders, tblFloppy.Totalheads,
tblFloppy.Totalsectors, tblFloppy.Totaltracks, tblFloppy.TracksperCylinder
From tblComputers Inner Join
tblFloppy On tblComputers.Computername = tblFloppy.Computername
Order By tblComputers.ComputerUnique, tblFloppy.Name

To use the specified report, do the following:
• Open the Lansweeper configuration console and select Reports & Alerts\Report Builder. Hit the “New” button.
• Copy the SQL code provided and paste it at the bottom of the newly created report, replacing the default SQL code.
• Click somewhere near tblComputers so the new code applies.
• Give the report a “View name” and a “Report name” and hit the “Save” button.
• Double-click on the report in the report list to see its results and export options.