Adding Some more details.. there are the databases with the same name for different servers.

When I execute the Database Space Capacity Report, it's not showing all databases in all instances. Please Help.

Okay here is the scenario.

I am creating a DBA Report where I need to show the backup details for last 15 days including today's date.

I have 2 variables @StartDate...

This is used because if Current Date is less than 7th of the month, it should go to previous month to set the start date

What if today's date is 5th January' 2016.

Will it show the start date as 21st December'2015 and End date as 5th January'2016

Hi Scott,

I just need the current date and a date before 15 days to find out whatever backups I took during the last 15 days.

I changed the code as,...

Hi Scott,

I executed the code today..

Declare @StartDate Datetime,

@EndDate Datetime

if DAY(@StartDate) >= 7

set @StartDate = DATEADD(day, -15, DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 0))

else

set @StartDate = DATEADD(DAY, -1, DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()),...

Thanks a bunch Scott..

The Partition is not NTFS Compressed. I am not able to see the file groups as the database is in restoring state.