Small and medium business | Business Central, N...

Get-NAVServerSession change time zone

(0) Share

Report

Posted on by Community Member

Hi all,

When i use "Get-NAVServerSession " from powershell i get the UTC time zone, but i need my time zone, in this case UTC+1.

ServerInstanceID SessionID UserSID ServerInstanceName ServerComputerName UserID ClientType ClientComputerName LoginDatetime DatabaseNa
---------------- --------- ------- ------------------ ------------------ ------ ---------- ------------------ ------------- ----------
1111 2947 id user bbdd server USUARIO WindowsClient EQUIPO 1 15/04/2021 5:54:12 BBDD -->time zon utc
1111 2949 id user bbdd server USUARIO WindowsClient EQUIPO 2 15/04/2021 5:58:31 BBDD --< time zone utc

thanks in advance.

All responses (4)

Answers (0)

Community Member on at

Like (0)

Report

RE: Get-NAVServerSession change time zone

Thanks
Community Member on at

Like (0)

Report

RE: Get-NAVServerSession change time zone

Thnaks !!!
Suggested answer

Suresh Kulla 47,787 on at

Like (0)

Report

RE: Get-NAVServerSession change time zone

You could write something like this

Function Get-LocalTime($UTCTime)

{

$strCurrentTimeZone = (Get-WmiObject win32_timezone).StandardName

$TZ = [System.TimeZoneInfo]::FindSystemTimeZoneById($strCurrentTimeZone)

$LocalTime = [System.TimeZoneInfo]::ConvertTimeFromUtc($UTCTime, $TZ)

Return $LocalTime

}

$sessions = Get-NAVServerSession -ServerInstance NAV2016

foreach($session in $sessions)

{

Write-Output Get-LocalTime($session.LoginDateTime)

}
Suggested answer

srttel on at

Like (0)

Report

RE: Get-NAVServerSession change time zone

The LoginDate is stored as UTC time format on the SQL Server.

So the cmdlet will return the value in UTC.

But you can format or recalculate the value once you have retrieved it.

$myvar = Get-NAVServerSession bc180

$myvar.LoginDatetime