What's the actual invoke-sqlcmd call that you're making - it's not shown in the image you provided. Also, what do you have set for your -QueryTimeout value? Is it possible you're...

You can set up a SQL Agent job with a schedule that will run on the last day of every month and does that for you.

Revising my previous version
CREATE TABLE #temp
(
[Pkey] INT,
[ParentId] INT,
[Status] VARCHAR(40),
[Datelogged] DATETIME
)

INSERT INTO #temp
VALUES
(1,123,'Submitted','12/9/2018 10:30'),
(2,123,'Assigned','12/9/2018 10:40'),
(3,123,'Acknowledge','12/9/2018 10:45'),

You can use LEAD to get the time between OnHold and the next status

CREATE TABLE #temp
(
[Pkey] INT,
[ParentId] INT,
[Status] VARCHAR(40),
[Datelogged] DATETIME
)

I should've asked earlier, but did you set up the mirroring with certificates?

In addition to identifying the heaps via the NULL index name, if you're using sys.dm_db_index_usage_stats it won't include information for anything that hasn't been touched at all, which can be...

You can't restore a backup from 2008 R2 to 2008 -it's only forward compatible, which is why you can restore it on a 2017 instance.

I use something similar to the below for some ad-hoc scripts I have:

DECLARE @test-2 TABLE
(
  [CompanyNid] INT,
  [Produce(Commodity)] VARCHAR(MAX)