myITforum.com Community Forum myITforum.com Community Forum

Home  Forums  Blogs  Live Support chat  Search Articles  Wiki  FAQ  Email Lists  Register  Login  My Profile  Inbox  Address Book  My Subscription  My Forums 

Photo Gallery  Member List  Search  Calendars  FAQ  Ticket List  Log Out

All Forums RSS Feed Subscription:


  


Creating a hardware inventory list for company assets report

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
  Printable Version
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Creating a hardware inventory list for company assets report Page: [1]
Login
Message << Older Topic   Newer Topic >>
Creating a hardware inventory list for company assets r... - 7/28/2008 7:39:31 AM   
LeonIRL

 

Posts: 2
Score: 0
Joined: 7/28/2008
Status: offline 		*To Mods: not sure where I was supposed to put this so please move it as required*

Hi all,

Im new to SMS 2003, meaning ive never used it before, and ive been given the task of creating a report of all company IT assets i.e. basically a hardware inventory.

Could someone please direct me as to where I should start. I need to create a spreadsheet so is there some way of exporting an inventory list to Excel etc?

Regards,
Leon

Post #: 1
RE: Creating a hardware inventory list for company asse... - 7/28/2008 7:53:24 AM   
skissinger


Posts: 2114
Score: 134
Joined: 9/13/2001
From: Sherry Kissinger
Status: offline 		If you haven't yet done so, I'd start by looking at your existing web reports.  Although your reporting point could be on an alternate server, in general most Administrators enable it on the Central (the top) Primary Site server.  Assuming you know the name of that server, and your 3-digit Site Code (if you don't know it, look on your own computer, in Control Panel, System Management, the last tab--the 3 digit site code will be there.  Then, from a web browser, input   http://YourCentralSiteServerName/SMSReporting_Your3DigitSitecode.        like http://SMSServer/SMSReporting_ABC

I'm also assuming your SMS Administrator didn't change defaults when creating the Reporting point.

Check out the reports that exist; and see if one or a combination of several will suffice.  At least you'll get a general idea of the data available to you.

As for exporting it to excel, once you have the results of a report in your web browser, at the top is "Export", which exports the results you see on-screen to a .csv file.

_____________________________

mofmaster@smsexpert.com (version 2007) | http://www.smsexpert.com | http://www.sccmexpert.com
My Blog
Microsoft MVP - ConfigMgr

(in reply to LeonIRL)
Post #: 2
RE: Creating a hardware inventory list for company asse... - 7/28/2008 9:33:56 AM   
LeonIRL

 

Posts: 2
Score: 0
Joined: 7/28/2008
Status: offline 		Thanks for the help!

(in reply to skissinger)
Post #: 3
RE: Creating a hardware inventory list for company asse... - 7/30/2008 5:21:57 AM   
mgroenewald

 

Posts: 197
Score: -2
Joined: 7/2/2004
Status: offline 		Hope this helps a bit

this will show unique records for all versions of xp
SELECT  V_GS_System.Name0 AS 'Computer Name',  v_GS_COMPUTER_SYSTEM.Username0 as 'User Name',  v_GS_Operating_System.Name0 as 'Operating System',                  max(V_GS_X86_PC_MEMORY.TotalPhysicalMemory0) as 'Total Memory',  max(v_GS_Disk.Size0) as 'Hardrive Size',  max(v_GS_Logical_Disk.FreeSpace0) AS 'Free Space',                   max(v_GS_Processor.CurrentClockSpeed0) as 'CPU Speed' From         v_GS_SYSTEM,  v_GS_COMPUTER_SYSTEM,  v_GS_Operating_System,  V_GS_X86_PC_MEMORY,  v_GS_Disk,  v_GS_Logical_Disk,  v_GS_Processor Where  v_GS_SYSTEM.ResourceID=v_GS_COMPUTER_SYSTEM.ResourceID    and          v_GS_SYSTEM.ResourceID=V_GS_X86_PC_MEMORY.ResourceID and        v_GS_SYSTEM.ResourceID=v_GS_Operating_System.ResourceID and           v_GS_SYSTEM.ResourceID=v_GS_Disk.ResourceID and         v_GS_SYSTEM.ResourceID=v_GS_Processor.ResourceID and             v_GS_SYSTEM.ResourceID=v_GS_Logical_Disk.ResourceID group by   V_GS_System.Name0,  v_GS_COMPUTER_SYSTEM.Username0,  v_GS_Operating_System.Name0


(in reply to LeonIRL)
Post #: 4
Page:   [1]
All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003 >> Creating a hardware inventory list for company assets report Page: [1]
Jump to:





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts



  
Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI

1.125