Using Invoke-SqlCmd you specify the server instance, the database, the authentication (defaults to windows authentication), the query and the variables.  Fixing up your SQL code - here is how that...

• This reply was modified 1 week, 4 days ago by  Jeffrey Williams.

Yes - you can use SSRS 2019 and connect to your 2012 instance as well as any other instance in your domain.  Create a new server, install the database engine...

Yes - Windows Update does include SQL Server updates.  Normally they are optional - but it all depends on how you have this setup and configured in your environment.  It...

The DNS CNAME only references the IP address - which is the SQLA to SQLB portion of an instance name.  To resolve the instance name change you will need to...

Interesting - you must have started SQLCMD window and not a DOS command window.  That isn't an option on my Windows 10 system - but doesn't really matter.

Go here:

If you are able to run SQLCMD and login - then you should be able to download SSMS and use that to access the system.  You said you were able...

SO I created a table in SQL that has many of the key fields

doc_bu doc_tp doc_filename doc_date doc_type

The doc_filename has the file name that the PS script found, and...

So now you want a column named 'User' with the value 'Total Minutes' - where before it was 'Report' and in your original code is was the user name.  I...

I don't understand what results you want.  Please provide sample data and expected results.

If you have a question on the code, then show which code and your question.

A single query can't return a variable number of columns.    It would have to reflect one column for every month of the year and a total at the...

This is what you had in your original query:

SELECT ISNULL([User],'UNKNOWN') as td,''

That is not a 'dummy' value...but if you really just want a dummy value - then use this:

            
March 29, 2021 at 8:49 pm
            
#3863373

            
            
                                                
        

You could change your function to this:

CREATE FUNCTION [dbo].[fnGetSeconds]
(
	@TimeFormatted varchar(10)
)
RETURNS Table
WITH schemabinding
AS
  RETURN
  SELECT (LEFT(@TimeFormatted,2)*3600) +
       ROUND(DATEDIFF(MS, 0, '00'...

I don't understand - your original query had the user - but now...

Also - don't sort the data in SQL Server, and depending on the report(s) you want you may consider just returning detail data from the stored procedure without any grouping...

You should convert your 'script' to a stored procedure with parameters.  Then in Report Builder you will use the stored procedure as the source for your data and build report...