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.

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

srttel on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

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)

}

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thnaks !!!

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks

Was this reply helpful? Yes No