This Question is Answered

8 Replies Last post: Dec 30, 2008 10:48 AM by Jack Coates  
Chyr Ye Hong Rookie 8 posts since
Feb 23, 2008
Currently Being Moderated

Nov 30, 2008 6:37 PM

Capture inventory history in reports?

Hi all

 

Wonder if its possible to create a report which shows the inventory history of a particular inventory item? e.g. If I enable Inventory History for Computer.Memory.Physical.Bytes Total, can I later generate a report for all devices which I have upgraded RAM and how much was the upgrade/difference?

 

Chyr

Jack Coates Expert 548 posts since
Nov 16, 2007
Currently Being Moderated
1. Nov 30, 2008 9:11 PM in response to: Chyr Ye Hong
Re: Capture inventory history in reports?

not from within the product, no. You'll need to access the database directly (think Crystal Reports) and pull from the inventoryhistory table.

vojtab Rookie 10 posts since
Apr 5, 2008
Currently Being Moderated
2. Dec 1, 2008 12:03 AM in response to: Jack Coates
Re: Capture inventory history in reports?

I have been looking for similar functionality. There is a product out there called iRecall that utlimately does the entire inventory history. It might be more than you are looking for but possibly worth considering.

Henk Hillaert Apprentice 14 posts since
Jan 3, 2008
Currently Being Moderated
4. Dec 30, 2008 2:45 AM in response to: Jack Coates
Re: Capture inventory history in reports?

What should we do to get in the canned reports? So many times this question has been asked?

vojtab Rookie 10 posts since
Apr 5, 2008
Currently Being Moderated
5. Dec 30, 2008 8:41 AM in response to: Henk Hillaert
Re: Capture inventory history in reports?

You don't get it out-of-the-box. If you want canned reports, you need to contact NetworkD and ask them about iRecall.

rhyous Expert 615 posts since
Nov 19, 2007
Currently Being Moderated
6. Dec 30, 2008 9:01 AM in response to: Henk Hillaert
Re: Capture inventory history in reports?

If you want to guarantee something is in the product that is not in the product, such as a report your want, you have to pay for it yourselves.  If you work with your reseller to cost the time to have the report created, it is usually simple to add the report to the next version.

 

If you submit an enhancement, there is no guarantee the enhancement will even make the radar of things needed to add to the next version.

rhyous Expert 615 posts since
Nov 19, 2007
Currently Being Moderated
7. Dec 30, 2008 10:01 AM in response to: Chyr Ye Hong
Re: Capture inventory history in reports?

By the way...in this instance I don't see why you cannot do this very easily by running a CSV report now.  And then running the same report later and merging the two.

 

Create a CSV report that has two fields:

 

Computername, Bytes Total

machine1, 256 MB

machine2, 384 MB

etc...

 

 

Then do the same report after the upgrade.

Computername, Bytes Total

machine1, 512 MB

machine2, 1024 MB

etc...

 

Now open both csv file in excel, and copy the Bytes Total column from the second report to the first report.  Add a subtraction in the fourth column.

 

Computername, Original Bytes Total, New Bytes Total, Difference

machine1, 256 MB, 512 MB, 256MB

machine2, 384 MB, 1024 MB, 640MB

etc...

 

Now you have all you data in excel and you can do any of the pretty excel charts you want.

Jack Coates Expert 548 posts since
Nov 16, 2007
Currently Being Moderated
8. Dec 30, 2008 10:48 AM in response to: rhyous
Re: Capture inventory history in reports?

Here's more information and some examples of this technique in action: http://www.droppedpackets.org/inventory-and-slm/interxtips2007.ppt/view

More Like This

  • Retrieving data ...
LANDesk Community powered by Jive Software's Clearspace ®                                                                        Subscribe| Legal Notices| Investor Relations| Privacy Policy © 2007 LANDesk Software