Custom Inventory pull CSV
Updated: 21 May 2010 | 7 comments
Can custom inventory read a CSV file and import that into a table? Unfortunatly the sample ftp site requires a password so I can't snoop in their first: https://kb.altiris.com/article.asp?article=4237&p=1
Example CSV
Timestamp,MachineType,MachineModel,MachineSerial,BatteryBarcode,BatteryFRU,BatteryError,BatteryCapacity,BatteryAge,FulfillmentURL
2009-10-15 00:07:16,6477,XXX,L3BXXX,1ZEXXXXXX,42TXXX,NO,OKAY,TOO_OLD,http://download.lenovo.com/lenovo/content/batt/082009/Unaffected.html?lang=en
discussion Filed Under:
Comments
I've sent off a request to see if we
can get that password issue resolved. In the meantime, custom inventory can read .ini files, registry entries and WMI. I've never tried with any other type. You could however, if you are using Asset\CMDB, import the .csv (and create any needed dataclasses).
Jim Harings
HP Enterprise Services
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect club.
Now I need an option for the
Now I need an option for the ini files :-)
Can you post an example?
This is the file I need to read:
[SYSTEM]
BUILD_DATE=10-05-09
COMPUTER=COMPUTERNAME
USER=USERNAME
SITE=New York
FILESERVER=FILESERVERNAME
MUI=US
[BUILD SERVER]
SOURCE=ALTS
DRIVE=v:
[DRIVER COPY]
MODELNUMBER=0GU083
MATCHMODEL=0GU08
MODEL=P490
[OFFICE]
MSOFFICE=OFFICE2007
Yes, connector Solution
Yes, connector Solution specifically does this very quickly and easily.
In fact if you have Asset Management Suite with Connector that would probably be the easiest way.
- Matt
Each individual client
Each individual client computer will create a CSV file that will need to be imported. Hence I was looking at custom inventory.
Could you redirect the output to the registry?
If not, the HP battery utility can be deployed, but I don't think it can be managed or gather any data, via the HP Client Manager utility.
Jim Harings
HP Enterprise Services
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect club.
This is the Lenovo one. I
This is the Lenovo one. I found a work around I guess. The Lenovo tool also creates a regkey with the return code. This will give me some basic info of the battery check status. However it will be missing some extra info like battery serial number.
FYI
Here is my custom inventory if anyone else needs to do the same thing.
<InventoryClasses>
<InventoryClass name="LenovoBattery" manufacturer='<YOUR COMPANY NAME HERE>' description='' platform='Win32' version='1.0' mifClass='Altiris|CUSTINV01|1.0'>
<xml xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema">
<s:Schema id="RowsetSchema">
<s:ElementType name="row" content="eltOnly" rs:updatable="true">
<s:AttributeType name="c0" rs:name="ReturnCode" rs:number="1" rs:keycolumn="true" mifAttrId="1">
<s:datatype dt:type="string" dt:maxLength="50"/>
</s:AttributeType>
<s:AttributeType name="c1" rs:name="Timestamp" rs:number="2" rs:keycolumn="true" mifAttrId="2">
<s:datatype dt:type="dateTime" dt:maxLength="255"/>
</s:AttributeType>
</s:ElementType>
</s:Schema>
<rs:data>
<%set path="HKEY_Current_User\Software\LENOVO\BatteryDiagnosticTool"%>
<z:row
c0="<%writexml "reg:%path%\ReturnCode"%>"
c1="<%writexml "reg:%path%\Timestamp"%>"
/>
</rs:data>
</xml>
</InventoryClass>
</InventoryClasses>
Would you like to reply?
Login or Register to post your comment.