private ICollection <UsageObject> GetDatabaseUsages(DataAccess.SQLDatabase database) { var result = new List <UsageObject>(); result.AddRange(SQLDatabaseUsageClient.CreateServerUsagesClient(database.Servername, database.Username, database.Password).GetUsages(DateTime.UtcNow.AddHours(-1))); var databaseNames = SQLDatabaseUsageClient.ListUserDatabases(database.Servername, database.Username, database.Password); foreach (var dbName in databaseNames) { result.AddRange(SQLDatabaseUsageClient.CreateDatabaseUsagesClient(database.Servername, dbName, database.Username, database.Password).GetUsages()); } return(result); }
private ICollection <UsageObject> GetDatabaseUsages(DataAccess.SQLDatabase database) { return(SQLDatabaseUsageClient.CreateServerUsagesClient(database.Servername, database.Username, database.Password).GetUsages(DateTime.UtcNow.AddHours(-1))); }