03-23-2012 10:32 AM
Solved! Go to Solution.
03-23-2012 10:56 AM
Select tblCustDevices.DeviceKey, tblCustDevices.Ipaddress, tblCustDevices.Mac,
tblCustDevices.Devicetype, tblCustDevices.State, tblCustDevices.Displayname,
tblCustDevices.Description, tblCustDevices.Location, tblCustDevices.Vendor,
tblCustDevices.Contact, tblCustDevices.Model, tblCustDevices.BarCode,
tblCustDevices.Serialnumber, tblCustDevices.Building,
tblCustDevices.Department, tblCustDevices.Branchoffice,
tblCustDevices.PurchaseDate, tblCustDevices.Warrantydate,
tblCustDevices.Custom1, tblCustDevices.FirstSeen, tblCustDevices.LastSeen,
tblCustDevices.LastSaved
From tblCustDevices
Order By tblCustDevices.Devicetype, tblCustDevices.Displayname
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblCompCustom.PurchaseDate, tblCompCustom.Warrantydate,
tblCompCustom.Location, tblCompCustom.Building, tblCompCustom.Department,
tblCompCustom.Branchoffice, tblCompCustom.State, tblCompCustom.Lastchanged,
tblCompCustom.BarCode, tblCompCustom.Custom1, tblCompCustom.Lastsaved,
tblCompCustom.Firstseen, tblCompCustom.Lastseen
From tblComputers Inner Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Order By tblComputers.ComputerUnique
03-23-2012 02:29 PM
Delete history from all history tables after
Delete event log entries after
Delete logon information after
03-23-2012 02:21 PM
03-23-2012 01:34 PM
03-23-2012 02:10 PM
helpdesktrv wrote:
I've another question for you: our MDF file is almost 2GB, so, can i optimize it in any way? Is there a way?
03-23-2012 10:56 AM
Select tblCustDevices.DeviceKey, tblCustDevices.Ipaddress, tblCustDevices.Mac,
tblCustDevices.Devicetype, tblCustDevices.State, tblCustDevices.Displayname,
tblCustDevices.Description, tblCustDevices.Location, tblCustDevices.Vendor,
tblCustDevices.Contact, tblCustDevices.Model, tblCustDevices.BarCode,
tblCustDevices.Serialnumber, tblCustDevices.Building,
tblCustDevices.Department, tblCustDevices.Branchoffice,
tblCustDevices.PurchaseDate, tblCustDevices.Warrantydate,
tblCustDevices.Custom1, tblCustDevices.FirstSeen, tblCustDevices.LastSeen,
tblCustDevices.LastSaved
From tblCustDevices
Order By tblCustDevices.Devicetype, tblCustDevices.Displayname
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblCompCustom.PurchaseDate, tblCompCustom.Warrantydate,
tblCompCustom.Location, tblCompCustom.Building, tblCompCustom.Department,
tblCompCustom.Branchoffice, tblCompCustom.State, tblCompCustom.Lastchanged,
tblCompCustom.BarCode, tblCompCustom.Custom1, tblCompCustom.Lastsaved,
tblCompCustom.Firstseen, tblCompCustom.Lastseen
From tblComputers Inner Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Order By tblComputers.ComputerUnique
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now