02-23-2009 06:29 PM
Solved! Go to Solution.
11-30-2011 12:53 PM
virtualgeek wrote:
I'm new to LS and was wonder how can I change the default values from 1Gb(1024) to another number or to simply create a new custom rule for 2GB?
Thanks,
VG
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
Web40OSName.OSname, tblOperatingsystem.Description, tblDiskdrives.Caption,
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) As
Free, Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) As
[Total size], tblDiskdrives.Lastchanged As [Last changed],
Web40OSName.Compimage As icon
From tblComputers Inner Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername
Where Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) <
2048 And Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) <>
0 And tblComputersystem.Domainrole < 2 And tblDiskdrives.DriveType = '3'
Order By Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric),
tblDiskdrives.Caption
01-04-2012 05:16 AM
01-04-2012 02:57 PM
virtualgeek wrote:
I would like to know how to create more than one report for disks, current we have a server one for 3GB. How can I copy this rule to create one that reports between 3GB and 5GB?
virtualgeek wrote:
I have the Premium version, where is the report builder tool as I can't seem to find it?
virtualgeek wrote:
Also, is there a way to have LS email me when drive goes below a certain threshold?
11-30-2011 04:02 AM
11-30-2011 12:53 PM
virtualgeek wrote:
I'm new to LS and was wonder how can I change the default values from 1Gb(1024) to another number or to simply create a new custom rule for 2GB?
Thanks,
VG
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
Web40OSName.OSname, tblOperatingsystem.Description, tblDiskdrives.Caption,
Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) As
Free, Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) As
[Total size], tblDiskdrives.Lastchanged As [Last changed],
Web40OSName.Compimage As icon
From tblComputers Inner Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername
Where Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric) <
2048 And Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) <>
0 And tblComputersystem.Domainrole < 2 And tblDiskdrives.DriveType = '3'
Order By Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 As numeric),
tblDiskdrives.Caption
02-23-2009 10:45 PM
02-23-2009 10:46 PM
Lansweeper wrote:
Our premium version has a report builder to build and change these kinds of reports.
But if you have sql knowledge you can go in the database and change the views yourself.
CREATE VIEW dbo.web30repHDDFreeWorkstations
AS
SELECT TOP 100 PERCENT dbo.tblComputers.Computername AS Computer, dbo.tblOperatingsystem.Description, dbo.tblDiskdrives.Caption,
CAST(CAST(dbo.tblDiskdrives.Freespace AS bigint) / 1024 / 1024 AS numeric) AS Free, CAST(CAST(dbo.tblDiskdrives.Size AS bigint)
/ 1024 / 1024 AS numeric) AS [Total size], dbo.tblDiskdrives.Lastchanged AS [Last changed]
FROM dbo.tblComputers INNER JOIN
dbo.tblDiskdrives ON dbo.tblComputers.Computername = dbo.tblDiskdrives.Computername INNER JOIN
dbo.tblOperatingsystem ON dbo.tblComputers.Computername = dbo.tblOperatingsystem.Computername INNER JOIN
dbo.Web30repAllWorkstations ON dbo.tblComputers.Computername = dbo.Web30repAllWorkstations.Computername
WHERE (dbo.tblDiskdrives.DriveType = '3') AND (CAST(CAST(dbo.tblDiskdrives.Freespace AS bigint) / 1024 / 1024 AS numeric) < 1024) AND
(CAST(CAST(dbo.tblDiskdrives.Size AS bigint) / 1024 / 1024 AS numeric) <> 0) AND (dbo.tblDiskdrives.Caption = 'C:')
ORDER BY CAST(CAST(dbo.tblDiskdrives.Freespace AS bigint) / 1024 / 1024 AS numeric), dbo.tblComputers.Computername, dbo.tblDiskdrives.Caption
02-23-2009 09:46 PM
02-23-2009 10:34 PM
Lansweeper wrote:
You can use all kinds of reports in the dashboard and place them where you want.
To edit this report you need to edit view : web30repHDDFreeWorkstations
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now