Month: February 2016

[Lansweeper]Workstations less than 2.0 GB free on System Drive (with username and display name)

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tsysOS.OSname,
tblAssets.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],
tsysOS.Image As icon,
tblAssets.Username,
tblADusers.Displayname
From tblAssets
Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblADusers On tblAssets.Username = tblADusers.Username
Where tblDiskdrives.Caption = ‘C:’ And 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 And tblAssetCustom.State = 1
Order By tblAssets.AssetUnique

Advertisements

Combination key to initialize HDD for Fuji Xerox copier

The combination key “6 + Stop + Power Save” can be use to initialize the HDD on Fuji Xerox copier.

First power off the copier and the main power. While pressing the combination key, power on the machine (main power then power on). You should see a message that the HDD is initializing on the screen.

Windows 10 update setting that you may want to disable

In Windows 10, there is a setting that you may want to disable, it is the “Updates from more than one place function”. Click on the Notification Center icon, select All settings, Update & security, Windows update, Advanced options, Choose how updates are delivered.

From there, you should have the option to disable this function, which would send and receive updates to other computers.