definitely, oh well...

there are too many chitters lately.

it would be great to remove this article not to create confusions.

thank you for the article, but it is really misleading and not providing much useful information.

SET NOCOUNT ON

SELECT @@VERSION [VERSION],

CONVERT(VARCHAR(100), SERVERPROPERTY('Servername')) Servername ,

CONVERT(VARCHAR(100), SERVERPROPERTY('ProductVersion')),

CONVERT(VARCHAR(100), SERVERPROPERTY('ProductLevel')) Product_SP_Level,

CONVERT(VARCHAR(100), SERVERPROPERTY('ResourceLastUpdateDateTime'))ResourceLastUpdate,

CONVERT(VARCHAR(100), SERVERPROPERTY('ResourceVersion'))ResourceVersion,

ISNULL(CONVERT(VARCHAR(100), CASE

...

you can use register servers and run one of the proposed queries or you can create list of servers and run PS as below:

$Servername=("SQLC-EST-IN-N5\INTERNAL","SQL1", "SQL2","SQL..n")

foreach ($Server in $Servername)

{

$output += (invoke-sqlcmd...

you can also restore from full backup with norecovery and then only transfer the latest trn backups (alternative to log shipping), restore them.

of course depends how big the trn backups,...

Both good solutions - thanks!