‎07-24-2012 11:29 AM
Solved! Go to Solution.
‎07-26-2012 05:26 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, TsysChassisTypes.ChassisName,
tblComputersystem.Manufacturer, tblComputersystem.Model,
web40AllIPLocations.IPLocation, Web40OSName.OSname, Web40OSName.OScode,
tblOperatingsystem.InstallDate, Web40OSName.SP,
tblOperatingsystem.SerialNumber, tblComputers.Username,
tblComputers.Userdomain, tblSystemEnclosure1.SerialNumber As SerialNumber1,
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, web40CorrectMemory.Memory,
web40ProcessorCapacity.NrOfProcessors, web40ProcessorCapacity.CPU,
tblComputers.LastknownIP, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher
From tblComputers Left Join
tblSystemEnclosure On tblComputers.Computername =
tblSystemEnclosure.Computername Inner Join
TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes Left Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Left Join
web40AllIPLocations On web40AllIPLocations.Computername =
tblComputers.Computername Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Left Join
tblSystemEnclosure tblSystemEnclosure1 On tblComputers.Computername =
tblSystemEnclosure1.Computername Left Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Left Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername Left Join
web40ProcessorCapacity On web40ProcessorCapacity.Computername =
tblComputers.Computername Inner Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Where tblDiskdrives.DriveType = 3
Order By tblComputers.ComputerUnique, tblSoftware.softwareName,
tblSoftware.softwareVersion
Select tblCustDevices.Displayname, tsysDevicetypes.ItemTypename,
tblCustDevices.Vendor, tblCustDevices.Model,
web40AllIPLocationsDev.IPLocation, tblCustDevices.Serialnumber,
tblCustDevHD.Filesystem, tblCustDevHD.Size, tblCustDevHD.Used,
tblCustDevHD.Available, tblCustDevHD.UsePCT, tblCustDevices.Ipaddress
From tblCustDevices Left Join
tblCustDevHD On tblCustDevices.DeviceKey = tblCustDevHD.DeviceKey Inner Join
tsysDevicetypes On tsysDevicetypes.ItemType = tblCustDevices.Devicetype
Left Join
web40AllIPLocationsDev On web40AllIPLocationsDev.DeviceKey =
tblCustDevices.DeviceKey
Order By tblCustDevices.IPNumeric, tblCustDevHD.Size
‎08-02-2012 04:38 PM
Select Distinct Top 1000000 tblComputers.Computername,
tblComputers.ComputerUnique, tblComputers.Domain
‎08-02-2012 04:24 PM
‎08-02-2012 03:19 PM
Select Distinct Top 1000000 tblComputers.Computername,
tblComputers.ComputerUnique, tblComputers.Domain,
TsysChassisTypes.ChassisName, tblComputersystem.Manufacturer,
tblComputersystem.Model, web40AllIPLocations.IPLocation, Web40OSName.OSname,
Web40OSName.OScode, tblOperatingsystem.InstallDate, Web40OSName.SP,
tblComputers.Username, tblSystemEnclosure.SerialNumber,
tblComputers.LastknownIP
From tblComputers Left Join
tblSystemEnclosure On tblComputers.Computername =
tblSystemEnclosure.Computername Inner Join
TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes Left Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Left Join
web40AllIPLocations On web40AllIPLocations.Computername =
tblComputers.Computername Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Left Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername Left Join
web40ProcessorCapacity On web40ProcessorCapacity.Computername =
tblComputers.Computername
Order By tblComputers.ComputerUnique
‎08-02-2012 11:25 AM - last edited on ‎06-16-2023 04:31 PM by Mercedes_O
I Customized the report so we can use it beter for the import.
But for some reason it shows some computers twice. See image.
How can i change this?
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Domain, TsysChassisTypes.ChassisName, tblComputersystem.Manufacturer, tblComputersystem.Model, web40AllIPLocations.IPLocation, Web40OSName.OSname, Web40OSName.OScode, tblOperatingsystem.InstallDate, Web40OSName.SP, tblComputers.Username, tblSystemEnclosure1.SerialNumber As SerialNumber, tblComputers.LastknownIP From tblComputers Left Join tblSystemEnclosure On tblComputers.Computername = tblSystemEnclosure.Computername Inner Join TsysChassisTypes On TsysChassisTypes.Chassistype = tblSystemEnclosure.ChassisTypes Left Join tblComputersystem On tblComputers.Computername = tblComputersystem.Computername Left Join web40AllIPLocations On web40AllIPLocations.Computername = tblComputers.Computername Left Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join tblOperatingsystem On tblComputers.Computername = tblOperatingsystem.Computername Left Join tblSystemEnclosure tblSystemEnclosure1 On tblComputers.Computername = tblSystemEnclosure1.Computername Left Join web40CorrectMemory On web40CorrectMemory.Computername = tblComputers.Computername Left Join web40ProcessorCapacity On web40ProcessorCapacity.Computername = tblComputers.Computername Inner Join tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername Where tblDiskdrives.DriveType = 3 Order By tblComputers.ComputerUnique
‎07-27-2012 10:47 AM
‎07-26-2012 05:26 PM
Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, TsysChassisTypes.ChassisName,
tblComputersystem.Manufacturer, tblComputersystem.Model,
web40AllIPLocations.IPLocation, Web40OSName.OSname, Web40OSName.OScode,
tblOperatingsystem.InstallDate, Web40OSName.SP,
tblOperatingsystem.SerialNumber, tblComputers.Username,
tblComputers.Userdomain, tblSystemEnclosure1.SerialNumber As SerialNumber1,
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, web40CorrectMemory.Memory,
web40ProcessorCapacity.NrOfProcessors, web40ProcessorCapacity.CPU,
tblComputers.LastknownIP, tblSoftware.softwareName,
tblSoftware.softwareVersion, tblSoftware.SoftwarePublisher
From tblComputers Left Join
tblSystemEnclosure On tblComputers.Computername =
tblSystemEnclosure.Computername Inner Join
TsysChassisTypes On TsysChassisTypes.Chassistype =
tblSystemEnclosure.ChassisTypes Left Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Left Join
web40AllIPLocations On web40AllIPLocations.Computername =
tblComputers.Computername Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Left Join
tblSystemEnclosure tblSystemEnclosure1 On tblComputers.Computername =
tblSystemEnclosure1.Computername Left Join
tblSoftware On tblComputers.Computername = tblSoftware.ComputerName Left Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername Left Join
web40ProcessorCapacity On web40ProcessorCapacity.Computername =
tblComputers.Computername Inner Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Where tblDiskdrives.DriveType = 3
Order By tblComputers.ComputerUnique, tblSoftware.softwareName,
tblSoftware.softwareVersion
Select tblCustDevices.Displayname, tsysDevicetypes.ItemTypename,
tblCustDevices.Vendor, tblCustDevices.Model,
web40AllIPLocationsDev.IPLocation, tblCustDevices.Serialnumber,
tblCustDevHD.Filesystem, tblCustDevHD.Size, tblCustDevHD.Used,
tblCustDevHD.Available, tblCustDevHD.UsePCT, tblCustDevices.Ipaddress
From tblCustDevices Left Join
tblCustDevHD On tblCustDevices.DeviceKey = tblCustDevHD.DeviceKey Inner Join
tsysDevicetypes On tsysDevicetypes.ItemType = tblCustDevices.Devicetype
Left Join
web40AllIPLocationsDev On web40AllIPLocationsDev.DeviceKey =
tblCustDevices.DeviceKey
Order By tblCustDevices.IPNumeric, tblCustDevHD.Size
‎07-24-2012 03:31 PM
‎07-24-2012 03:54 PM
Lansweeper wrote:
Could you clarify whether you want to create a computer or a device report. Devices are printers, routers, etc. In case of a computer report, please let us know as well which specific information besides serial you would like to include.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now