Well have to fall back on trusty SQL queries to do this...
This should work, but you may have to Tweak it....
@time = GetDate()
SiteName as 'Repository Name',
count(*) as 'COUNT'
TVDEventID = '2401'
and Type Like 'Dat%'
and EventDateTime > (@time-10)
How do I import this exactly?
I've copy pasted it into a textfile and tried importing it into our eposerver via "import query"
but I only receive an error:
The query could not be imported because the uploaded file is either corrupt or in an unexpected format. Click "OK" to return to the "Queries" page.
You cannot run this one through ePO. Only SQL, using SQL query analyzer or SQL Management Studio.