erikdarlingdata/DarlingData

@get_all_databases = 1 vs @get_all_databases = 0 result in different periods of 8 days

ehaar opened this issue · 3 comments

ehaar commented

Version of the script

@version = '4.5',
@version_date = '20240401'

What is the current behavior?
When executing the next statement

EXEC sp_QuickieStore @get_all_databases = 1
GO

then column 'period' in the second resultset shows a period from 8 days ago until today, which should be 7 days as a default. That's the first issue.
Second issue:
When executing the next statement

EXEC sp_QuickieStore @get_all_databases = 0
GO

then column 'period' in the second resultset shows a period from 7 days ago until tomorow, so 2 different periods that should be the same, and both spanning 8 days, which should be 7 days.

If the current behavior is a bug, please provide the steps to reproduce.

EXEC sp_QuickieStore @get_all_databases = 1
GO
EXEC sp_QuickieStore @get_all_databases = 0
GO

What is the expected behavior?
Column 'period' in the second resultset shows a period from 7 days ago up and until today (7 days).

erikdarlingdata commented

@ehaar yeah, I'm aware of this, it just hasn't seemed that important to anyone (myself included). Are you planning on working on this?

erikdarlingdata commented

@ehaar I haven't heard back from you on this, but if you decide you want to work on it, leave a comment and I'll re-open it.

ehaar commented