cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Sharjite
Engaged Sweeper
Good morning.

I need to generate a report in Excel sheet with the following fields: User, Username, Manufacturer/Model of CPU and its Serial No., Manufacturer/Model of Monitors and its serial no.

Can someone tell me what to do?

Thanks in advance.
5 REPLIES 5
jacn96
Engaged Sweeper
HEY!! how are you ?

these querys do not work in the latest version of lansweeper comes error "Msg 248, Level 16, State 1, Line 1
The conversion of the varchar value'2653134848 'overflowed has an int column. Above the maximum value. "


we can do?
tcostella
Engaged Sweeper
This works fine for me "except" I only get PC's that have Office 2003 Pro installed. Is there a way to remove that "filter"?

Thanks,

Thad

SELECT DISTINCT
CS.Computername AS 'Usuario', tblOperatingsystem.Description, CS.Domain AS 'Vinculado al Dominio', cs.PrimaryOwnerName AS 'Regitrado A',
tblComputerSystemProduct.IdentifyingNumber AS 'Serial', tblPROCESSOR.Name AS 'Tipo de Procesador y Velocidad', CS.TotalPhysicalMemory / 1000000 AS 'Memoria RAM',
DD.Size AS 'Disco Duro', tblBIOS.SerialNumber AS 'Serial Equipo', CS.Manufacturer AS 'Fabricante',
CS.Model As 'Modelo Equipo', tblSoftware.softwareName AS 'Version Office',
tblOperatingsystem.Caption AS 'Sistema Operativo'
FROM
tblSoftware AS tblSoftware INNER JOIN
tblComputersystem AS CS ON tblSoftware.ComputerName = CS.Computername INNER JOIN
tblComputers AS tblComputers INNER JOIN tblOperatingsystem AS tblOperatingsystem ON
tblComputers.Computername = tblOperatingsystem.Computername ON
CS.Computername = tblOperatingsystem.Computername INNER JOIN
tblPROCESSOR AS tblPROCESSOR ON tblSoftware.ComputerName = tblPROCESSOR.Computername INNER JOIN
tblDiskdrives AS DD ON CS.Computername = DD.Computername INNER JOIN
tblBIOS AS tblBIOS ON CS.Computername = tblBIOS.Computername INNER JOIN
tblComputerSystemProduct AS tblComputerSystemProduct ON CS.Computername = tblComputerSystemProduct.Computername

WHERE
(tblSoftware.softwareName = 'Microsoft Office Professional Edition 2003') AND (DD.Caption = 'C:')

ORDER BY 'Usuario'
jacn96
Engaged Sweeper
this Query is Whit the serial Computer
SELECT DISTINCT
CS.Computername AS 'Usuario', tblOperatingsystem.Description, CS.Domain AS 'Vinculado al Dominio', cs.PrimaryOwnerName AS 'Regitrado A',
tblComputerSystemProduct.IdentifyingNumber AS 'Serial', tblPROCESSOR.Name AS 'Tipo de Procesador y Velocidad', CS.TotalPhysicalMemory / 1000000 AS 'Memoria RAM',
DD.Size AS 'Disco Duro', tblBIOS.SerialNumber AS 'Serial Equipo', CS.Manufacturer AS 'Fabricante',
CS.Model As 'Modelo Equipo', tblSoftware.softwareName AS 'Version Office',
tblOperatingsystem.Caption AS 'Sistema Operativo'
FROM
tblSoftware AS tblSoftware INNER JOIN
tblComputersystem AS CS ON tblSoftware.ComputerName = CS.Computername INNER JOIN
tblComputers AS tblComputers INNER JOIN tblOperatingsystem AS tblOperatingsystem ON
tblComputers.Computername = tblOperatingsystem.Computername ON
CS.Computername = tblOperatingsystem.Computername INNER JOIN
tblPROCESSOR AS tblPROCESSOR ON tblSoftware.ComputerName = tblPROCESSOR.Computername INNER JOIN
tblDiskdrives AS DD ON CS.Computername = DD.Computername INNER JOIN
tblBIOS AS tblBIOS ON CS.Computername = tblBIOS.Computername INNER JOIN
tblComputerSystemProduct AS tblComputerSystemProduct ON CS.Computername = tblComputerSystemProduct.Computername

WHERE
(tblSoftware.softwareName = 'Microsoft Office Professional Edition 2003') AND (DD.Caption = 'C:')

ORDER BY 'Usuario'
jacn96
Engaged Sweeper
HI I´m Jose Armando i find this tool in the internet and i think that this tool is good tool EXCUSE MY ENGLISH i´m learning

SELECT DISTINCT

CS.Computername [Usuario] , tblOperatingsystem.Description [Descripcion PC], CS.Manufacturer [Fabricante], CS.Model [Modelo PC], CS.Domain [Dominio], tblOperatingsystem.RegisteredUser [Registrado A], tblPROCESSOR.Name [Procesador], CS.TotalPhysicalMemory / 1000000 [Memoria], DD.Size [Disco Duro], tblOperatingsystem.Caption [Sistema Operativo], tblSoftware.softwareName [Office]

FROM tblSoftware AS tblSoftware INNER JOIN

tblComputersystem AS CS ON tblSoftware.ComputerName = CS.Computername INNER JOIN

tblComputers AS tblComputers INNER JOIN

tblOperatingsystem AS tblOperatingsystem ON tblComputers.Computername = tblOperatingsystem.Computername ON

CS.Computername = tblOperatingsystem.Computername INNER JOIN

tblPROCESSOR AS tblPROCESSOR ON tblSoftware.ComputerName = tblPROCESSOR.Computername INNER JOIN

tblDiskdrives AS DD ON CS.Computername = DD.Computername

WHERE (tblSoftware.softwareName = 'Microsoft Office Professional Edition 2003') AND (DD.Caption = 'C:')

ORDER BY 1



ATT
Jose Armando Camacho Navarrete
Optilan
Engaged Sweeper
In Microsoft SQL Server Management Studio Create a new view and use this:

SELECT dbo.tblComputers.Username, dbo.tblComputers.Computername, dbo.tblComputerSystemProduct.IdentifyingNumber,
dbo.tblComputerSystemProduct.Vendor, dbo.tblComputerSystemProduct.Name, dbo.tblDesktopMonitor.MonitorManufacturer
FROM dbo.tblComputers INNER JOIN
dbo.tblComputerSystemProduct ON dbo.tblComputers.Computername = dbo.tblComputerSystemProduct.Computername INNER JOIN
dbo.tblDesktopMonitor ON dbo.tblComputers.Computername = dbo.tblDesktopMonitor.Computername

Save it, view it and copy the "cells" into an Excel sheet.

There isnt a monitor model or serial number field, i dont think it's possible to get one either.
Optilan Communication Systems www.optilan.com