|
|
Rank: Freeware user
Groups: Member
Joined: 5/12/2008
Posts: 7
Location: UAE
|
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.
|
|
Rank: Premium user
Groups: Member
, Premium Users
Joined: 1/24/2008
Posts: 13
Location: UK
|
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
|
|
Rank: Freeware user
Groups: Member
Joined: 5/14/2008
Posts: 3
Location: Bogota
|
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
|
|
Rank: Freeware user
Groups: Member
Joined: 5/14/2008
Posts: 3
Location: Bogota
|
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'
|
|
Rank: Premium user
Groups: Member
, Premium Users
Joined: 7/16/2008
Posts: 2
Location: Tempe, AZ
|
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'
|
|
|
Guest |
