Monitor file size, report on size over last 14 days

icky2000

I need to monitor the size of a file on a Windows server. This led me to the APM File Size Monitor template. I've modified the template to point to the file that I care about and applied the template to a server.

Now if I view that server's page in APM I can click on the customized template under Applications, I can see under Components the File Size Monitor and next to that the Statistic Data column which accurately reports the size of the file, in bytes. That's great.

I see that in the File Size Monitor template I can set some thresholds for min and max size but in my case I really wish to be able to view the size of the file over time. For instance, I'd like to view a report daily that shows the size of the file for the last 14 days. Can I assume that because I have this application monitoring this file size that this data is then being stored in the database so that I can report on it over time? Or is APM just looking at the file size occasionally and using that info to drive the thresholds in the template and that's it?

If the former, can you give me a few clues for how to create a report like this? For instance, what kind of report should I create and what fields would I be looking for? Or do I need to do an Advanced SQL report and need to know the table and column where this data is stored?

Thanks in advance!

Find more posts tagged with

custom_report

file_size

Accepted answers

josh.clark

SELECT c.Name, cs.TimeStamp, pe.MinStatisticData,
pe.MaxStatisticData, pe.AvgStatisticData
FROM APM_PortEvidence pe
JOIN APM_ComponentStatus cs ON cs.ID = pe.ComponentStatusID
JOIN APM_Application a ON a.ID = cs.ApplicationID
JOIN APM_Component c ON c.ID = cs.ComponentID
WHERE a.Name = 'MyApplication'

All comments

FormerMember

Can I assume that because I have this application monitoring this file size that this data is then being stored in the database

Yes. It's in the database.

can you give me a few clues for how to create a report like this

Unfortunately, that field is not exposed to our Report Writer. We'll get that fixed. In the meantime, you can use the Advanced SQL Query to get that data out of the database and into a report.

icky2000

Thanks. Can you point me to the table where this data is stored please? I can't seem to find it...

josh.clark

SELECT StatisticData FROM APM_AlertsAndReportsData

icky2000

Thanks, I was noodling around in tables and didn't think about it being a view.

So I can now create a report that gives me the size that was recorded during the last poll and I can adjust in the monitor itself how frequently it polls. That's great.

It would also be nice though if I could somehow also opt to have this data tracked historically. Unless I'm missing something, I think you're just polling on the selected frequency and storing only the result of that most recent poll, overwriting the previous value. If I want to see a historical graph or table in the report that shows the size of the file over time (ie the last 14 days), I'd have to somehow lookup that field daily and store the value off in another table somewhere myself. Not a huge problem but it would be nice if it was built in. Unless I'm missing something?

jerryjadechang

Hi,

Is the file size monitor (for windows) available in APM 2 or 2.5? I don't see it in 2.0.

Thanks,

Jerry Chang

ElisabethZakes

It's definitely in 2.5; see page 33 of the Administrator Guide, in the section on Templates:

File Size Monitor

This template measures the size of a file at the given file path. The statistic is the
file size in bytes.
Prerequisites: None.
Credentials: Windows credential with read access to the network share.

icky2000

Denny, you said in response to my last question that APM is storing the data historically. I thought I had found that data but I was wrong. So at this point I know the necessary SQL to get the most recent data and I understand that the historical data is in the db somewhere but I can't figure out the necessary SQL to look at it (ultimately so I can write a report to see the data for the last 30 days or so). Perhaps this is a bit much to ask for a forum question but can anyone help with the SQL?

Here's what I'm using to view the most recent data:

SELECT TOP 10000 APM_AlertsAndReportsData.ComponentName AS Component_Name,
APM_AlertsAndReportsData.StatisticData AS Statistic_Data

FROM
APM_AlertsAndReportsData

WHERE
(
(APM_AlertsAndReportsData.ApplicationName = 'MyApplication')
)