I have an Access database and within there is a table that has perf metric data in it (layout below)
I am trying to pull this infomration out of access and put it into the following format in excel or CSV so line charts and uploading can be done to our main CAP managment system
Time, memory % Committed Byte in use, Paging file % Usage, System Context Switches
4/14/2012 11:17:45 PM, 20.6496604287062, 6.94272741147741, 5899.05361730013
This is what I have so far, but I cant get it to format the right way, any ideas on what I am missing
$datassource = "C:\temp\perfdata.mdb"
$adapter = New-Object system.data.oledb.oledbdataadapter $objcmd
This gives me the following output
Terminal Services,Total Sessions,,4/17/2012 7:13:44 PM,1 which isnt right
All and any help apprecited
I'm not much of a db guy, but it looks like you may not be getting the data you want from the database.
What's ion the $adapter after you fill it? And what's in $dataset.Tables.rows?
As I do not have the database I can't really duplicate but hopefully this will help you to find the issue.