Inv_UNIX_User_Usage

[Sidnei Santana]

Inv_UNIX_User_Usage

Table Inv_UNIX_User_Usage

I need to understand how the data works in table Inv_UNIX_User_Usage, Because after inventory some login data of linux users disappear and for some inventoried servers the history is maintained.

Is there any way to keep this data?

[Igor Perevozchikov]

Hello Sidnei Santana!

It looks like "Inv_UNIX_User_Usage" table has more than 1 million rows?

Could you please amount of rows in this table? SELECT COUNT(*) FROM Inv_UNIX_User_Usage

What settings you have on this "Resource History" page for "User Usage"?

You can check "User Usage" checkbox and set Keep history duration and appropriate "Max Rows" and after save changes, new sql table will be created "InvHist_UNIX_User_Usage".

"User Usage" history records will be available from "Resource Manager" page for inventoried Linux machines

Looks strange that somehow previous inventoried data disappears for some Linux machine from "Inv_UNIX_User_Usage" table, but maybe there were merges of managed inventoried Linux machines?

Could you please open "Resource Manager" of affected Linux machine and check whether it had merge events and check why it merged with which other computer?

Best regards,
IP.

------------------------------

[Sidnei Santana]

You can check "User Usage" checkbox and set Keep history duration and appropriate "Max Rows" and after save changes, new sql table will be created "InvHist_UNIX_User_Usage".

I Will try this, thank you