I need a trick to parse reports...

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:

I need a trick to parse reports...

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 >> I need a trick to parse reports...

Page: [1]

Message

<< Older Topic Newer Topic >>

I need a trick to parse reports... - 7/31/2008 3:17:14 PM

kmarsicek173

Posts: 56
Score: 0
Joined: 2/28/2006
From: Chicago- Pinball capital of the world
Status: offline

Hello all,

I'm sure some of you run into this from time to time when generating reports from SMS queries, and I wonder if anybody has found a trick for it.

I have two spreadsheets. One was generated from another asset management database and lists workstations by asset tag. The other was generated from an SMS query and it lists computer names (our computer names contain a prefix followed by the asset tag).

What I need to do is compare the two spreadsheets. For each asset tag listed in the first spreadsheet, I need to find the corresponding computer name in the second spreadsheet.

In other words, say the first spreadsheet has a column with 3 asset tags - XXX, XXY, and XXZ. I need to combine the two spreadsheets and match those asset tags up with the computer names in the SMS spreadsheet column that would be HQXXX, HQXXY, and HQXXZ. What I'm trying to do is eliminate computer names for which there is no corresponding asset tag.

Anybody know any tricks to help me acheive that goal?

Thanks!!!

Post #: 1

RE: I need a trick to parse reports... - 7/31/2008 4:43:23 PM

jnelson993

Posts: 959
Score: 132
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

Well, you can do that with VLOOKUP...but instead of parsing exports of reports to come up with data that should really be another report, something mo-betta would be to just create a web report of your own using the data from that asset management database.

http://myitforum.com/cs2/blogs/jnelson/archive/2008/04/04/114622.aspx

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to kmarsicek173)

Post #: 2

RE: I need a trick to parse reports... - 7/31/2008 4:45:15 PM

jnelson993

Posts: 959
Score: 132
Joined: 2/18/2005
From: Minneapolis, MN
Status: offline

(and just for clarification, by VLOOKUP I mean the Excel formula VLOOKUP, not some separate program or anything) Hit F1 from Excel and look at the help for VLOOKUP to get the parameters.

_____________________________

Number2 (John Nelson)
MyITForum - Blog
MyITForum - Forum Posts

(in reply to jnelson993)

Post #: 3