AnsweredAssumed Answered

List Active Users\Listar usuários ativos

Question asked by Francisco Junior on Aug 8, 2017
Latest reply on Aug 9, 2017 by Francisco Junior

I need to migrate a base from openfire from MySQL to Postgresql, but there are many idlers I would like to migrate only the assets, for example only users who have logged in for the last 180 days. How do I get such information through the database?

 

My base has more than 5000 users

 

 

 

Portugues

 

 

Preciso migrar uma base do openfire de MySQL para Postgresql, mas tem muitos usuarios inativos eu gostaria de migrar somente os ativos, por exemplo somente os usuario que fizeram login nos ultimos 180 dias.

 

 

Como consigo tal informação pelo banco de dados?

 

Minha base possue mais de 5000 usuarios

Outcomes