Hey there.
Trying to work with PRTG reports and export a list of all sensors in a group, but containing device name and sensor ID, among some stats for those devices/sensors, in the exports. (best I've done so far was get the sensor ID as part of the exported filename).
Furthermore, we're trying to get some raw data extracted, but CSVExport (from PTF) isn't doing the trick. We can get lots of data out, but not the columns of data we need to extract, and no device names can be extracted. The CSV format is fully quoted and using the tools I have available to automate the process (bcp), I need to do post-processing to remove that formatting. The XML output format seems to require a DTD or format file that can translate the xml into rows/columns. Currently, running the BULK import query, I just get a bunch of garbage from that xml.
In the end, the purpose of this data extraction is to create a report for a client showing the uptime of our devices / sensors. Ideally, we'd like to get the data into SQL server so we can formulate queries and develop those reports automatically.
Any advice?
Add comment