Retrieve creation date of a group

YR
Yoan R Bronze Contributor
COPPERNIC

Hi, 

Is it possible to obtain the creation date of a group directly from the webconsole or via the DB ? 

Thank you in advance.

5 years ago
SOTI MobiControl
ANSWERS
D
DDMOD@SOTI Platinum Contributor
5 years ago

Hi Yoan,

Thanks for the post!

You can find the creation date of a Device Group on the MainLog table of MobiControl database/MobiControl DB archive depending upon the age of the group.

Look for the EventID '7119' in MainLog table.
 
 
Regards,
YR
Yoan R Bronze Contributor
5 years ago

Hi,

Thank you for your answer.

I don't have results for EventID '7119' in the MainLog table of MobiControl database/MobiControl DB.

Best regards,

D
DDMOD@SOTI Platinum Contributor
5 years ago (edited 5 years ago)

Hi Yoan,

Please execute the below query on MobiControl Archive Database to retrieve the creation date of Device Group. Change the Database name accordingly.

SELECT *
FROM [MobiControlDB_Archive].[dbo].[MainLog] where EventId = '7119'

 

Regards,

YR
Yoan R Bronze Contributor
5 years ago

Hi,

Thank you.

I still have no results :

D
DDMOD@SOTI Platinum Contributor
5 years ago

Thanks Yoan for the quick update. Can you please execute the same query on MainLog table of MobiControl database now?

Regards,

YR
Yoan R Bronze Contributor
5 years ago

Hi,

Sure no problem !

Same result (no result) :

Best regards,

D
DDMOD@SOTI Platinum Contributor
5 years ago

Hi Yoan,

Do you mind contacting SOTI Support team to help you in finding the creation dates of Device Groups?

You can raise a support case(click here) or call SOTI Support team(click here) anytime for further assistance.

Regards,

YR
Yoan R Bronze Contributor
5 years ago

Thank you !

Have a great day.

J
JVMOD@SOTI Platinum Contributor
5 years ago

Hello Yoan,

Thank you for your response, if this post has helped you in solving your inquiry, I would request you to mark the particular comment as "is solution", so others may benefit from this information.

Regards,

Similar Discussions