How to query the LiteSpeed Central database to return the data that displays in LiteSpeed Activity in the GUI Console
N/A
WORKAROUND:
From Query Analyzer in SSMS:
use LiteSpeedCentral
SELECT
LA.ServerName,
LAD.DatabaseName,
LAT.ActivityTypeName,
LAST.StatusName,
LA.StartTime,
LA.FinishTime,
LA.BackupTime,
LA.BackupSize
FROM
dbo.LitespeedActivity LA
INNER JOIN dbo.LitespeedActivityType LAT ON LA.ActivityTypeID = LAT.ActivityTypeID
INNER JOIN dbo.LiteSpeedStatusType LAST ON LA.StatusTypeID = LAST.StatusTypeID
INNER JOIN dbo.LiteSpeedDatabase LAD ON LA.DatabaseID = LAD.DatabaseID
WHERE
StartTime BETWEEN getdate() - 1 and getdate()
AND LAT.ActivityTypeName LIKE '%Backup%'
