nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Data missing from report

JustSomeGuy_at_work

I extracted a report to show application availability for the year, but I noticed that the data only goes as far back as March 2026. I checked the Database data retention period and it shows 365 days for Daily Statistics Retention. Is there a way to extract the remaining data? If not, can someone tell me what happened to the data? Any help would be appreciated.

Find more posts tagged with

sam

report

Accepted answers

ahawkins72

I hope I managed to understand the situation correctly! My laptop has blue screened 7, maybe 8 times this morning so I'm sorry it took me a bit to get back!

In my production environment, my SAM retention settings are 3/30/90 which I think is the default? I confirmed in the database that this seems to be the case. If your settings allow a greater retention period, then I would hope you can find the data you're looking for in the APM_ApplicationStatus_CS_Daily_hist table, (or replace Daily with Detail/Hourly if appropriate)

All comments

ahawkins72

Hey, if you could share a screenshot of your report setup or what your query looks like, that would be great! I know that some statistics are moved from table to table as they reach certain summarization thresholds (like from hourly to daily) so that is one thing that comes to mind. One of us could possibly lab it out and see if we can figure out the issue if we know exactly how you're doing it!

JustSomeGuy_at_work

Below are some of the queries I ran against Application tables. All of them are returning data as far back as 90 days. This only applies to the Application tables. The Nodes and Interface tables return data as far back as 2025. I desperately need Application uptime for the past 365 days. Is there a specific table I can find this data or should I use a different column for time?

SELECT MIN(TimeStamp) as Lowest
FROM Orion.APM.CurrentApplicationStatus

SELECT MIN(TimeStamp) AS LOWEST
FROM Orion.APM.ApplicationStatus

SELECT
QuarterOfYear(ApplicationStatus.TimeStamp) AS SummaryQuarter,
Nodes.Caption,
TimeStamp,
Nodes.DetailsUrl as NodesDetailsUrl,
Application.Name AS ApplicationName,
Application.DetailsUrl AS ApplicationDetailsUrl,
SUM(ApplicationStatus.PercentAvailability * ApplicationStatus.RecordCount) / SUM(ApplicationStatus.RecordCount) AS PercentAvailability
FROM Orion.APM.ApplicationStatus ApplicationStatus
INNER JOIN Orion.APM.Application Application ON Application.ApplicationID = ApplicationStatus.ApplicationID
INNER JOIN Orion.Nodes ON Nodes.NodeID = Application.NodeID
WHERE ApplicationStatus.TimeStamp >= ADDMINUTE(MINUTEDIFF(GETDATE(), GETUTCDATE()), ADDYEAR(YEARDIFF(0, GETDATE()), 0))
AND NodeName IN ('XXXX')
GROUP BY QuarterOfYear(ApplicationStatus.TimeStamp), Application.ApplicationID, Application.Name, TimeStamp, Nodes.Caption, NodesDetailsUrl, ApplicationDetailsUrl
ORDER BY SummaryQuarter

JustSomeGuy_at_work

SELECT MIN(TimeStamp) as Lowest
FROM Orion.APM.CurrentApplicationStatus

ahawkins72

I hope I managed to understand the situation correctly! My laptop has blue screened 7, maybe 8 times this morning so I'm sorry it took me a bit to get back!

JustSomeGuy_at_work

This is really helpful. It turns out the Daily Stats Retention that I was referring to was not for SAM. Thanks dude, I appreciate it!