packetchaos / navi

A Command-line tool which leverages the Tenable.io API to reduce the time it takes to get information that is common during remediation or a troubleshooting event
GNU General Public License v3.0
72 stars 26 forks source link

Empty Export files and Navi.db was only table definitions #23

Closed lingo2 closed 2 years ago

lingo2 commented 2 years ago

Downloaded and installed new docker yesterday . Navi update full completes without error . when I try export of any form I get no rows agent_data.csv asset_data.csv navi.db query_data.csv user_data.csv I have used navi export agents , navi export assets with no error s but get empty files . there also seems to no longer be a navi export vulns ?how should can export assets? navi find query "select * from assets;" gives an empty array . Navi display assets works shows me 4000 assets . Is there a process I missed to commit the data into the navi.db ?

packetchaos commented 2 years ago

Yes. You need to run navi update full, for compliance data run navi update compliance.

On Wed, Mar 9, 2022, 1:25 PM lingo2 @.***> wrote:

Downloaded and installed new docker yesterday . Navi update full completes without error . when I try export of any form I get no rows agent_data.csv http://127.0.0.1:8000/agent_data.csv asset_data.csv http://127.0.0.1:8000/asset_data.csv navi.db http://127.0.0.1:8000/navi.db query_data.csv http://127.0.0.1:8000/query_data.csv user_data.csv http://127.0.0.1:8000/user_data.csv I have used navi export agents , navi export assets with no error s but get empty files . there also seems to no longer be a navi export vulns ?how should can export assets? navi find query "select * from assets;" gives an empty array . Navi display assets works shows me 4000 assets . Is there a process I missed to commit the data into the navi.db ?

— Reply to this email directly, view it on GitHub https://github.com/packetchaos/navi/issues/23, or unsubscribe https://github.com/notifications/unsubscribe-auth/AHWPVTKOHUNR6KXJWX5QTWLU7ECMRANCNFSM5QKUAH6A . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you are subscribed to this thread.Message ID: @.***>

lingo2 commented 2 years ago

thanks Casey yes sorry did I not mention that Nav update full runs also without issue navi update full

Requesting Vulnerability Export with ID : ef41e378-e043-40c6-9d4a-49cac55cdc85 Status : FINISHED

Processing Time took : 3.526649236679077

Chunks Available - 0 Downloading chunks now...hold tight...This can take some time

Vulnerability Update Time took : 3.53115177154541

Creating a few indexes to make queries faster.

Requesting Asset Export with ID : caabb1c4-f395-4a60-acfd-3d3e4209db23 Status : PROCESSING

Processing Time took : 5.155491828918457 Asset Download took: 5.171783447265625

navi export assets

Exporting your data now. Saving asset_data.csv now...

navi find query "select * from assets;"

[]

On Thu, Mar 10, 2022 at 9:31 AM Casey Reid @.***> wrote:

Yes. You need to run navi update full, for compliance data run navi update compliance.

On Wed, Mar 9, 2022, 1:25 PM lingo2 @.***> wrote:

Downloaded and installed new docker yesterday . Navi update full completes without error . when I try export of any form I get no rows agent_data.csv http://127.0.0.1:8000/agent_data.csv asset_data.csv http://127.0.0.1:8000/asset_data.csv navi.db http://127.0.0.1:8000/navi.db query_data.csv http://127.0.0.1:8000/query_data.csv user_data.csv http://127.0.0.1:8000/user_data.csv I have used navi export agents , navi export assets with no error s but get empty files . there also seems to no longer be a navi export vulns ?how should can export assets? navi find query "select * from assets;" gives an empty array . Navi display assets works shows me 4000 assets . Is there a process I missed to commit the data into the navi.db ?

— Reply to this email directly, view it on GitHub https://github.com/packetchaos/navi/issues/23, or unsubscribe < https://github.com/notifications/unsubscribe-auth/AHWPVTKOHUNR6KXJWX5QTWLU7ECMRANCNFSM5QKUAH6A

. Triage notifications on the go with GitHub Mobile for iOS < https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675

or Android < https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub .

You are receiving this because you are subscribed to this thread.Message ID: @.***>

— Reply to this email directly, view it on GitHub https://github.com/packetchaos/navi/issues/23#issuecomment-1063337392, or unsubscribe https://github.com/notifications/unsubscribe-auth/AASPYAB25FZZG4BN6YAMKXTU7EDBFANCNFSM5QKUAH6A . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you authored the thread.Message ID: @.***>

-- Kind Regards Neil Hazelwood 0211788070

packetchaos commented 2 years ago

Okay. This is temporary 'fix' put into place after the RBAC changes. You're user is likely and admin. Go into Access Groups and make sure your Admin Account has explicit 'can scan' and 'can view' permissions in the "All Assets" Access Group.

While the UI shows you have complete access, the exports have been restricted. The solution is to explicitly provide permissions to the admin user. Once you provide explicit permissions, run the navi update full command and you will see you have data.

lingo2 commented 2 years ago

Thanks you Casey appreciate your prompt and erudite support , after changing the access rights data was exported fine . Thanks again Casey

On Thu, Mar 10, 2022 at 10:38 AM Casey Reid @.***> wrote:

Okay. This is temporary 'fix' put into place after the RBAC changes. You're user is likely and admin. Go into Access Groups and make sure your Admin Account has explicit 'can scan' and 'can view' permissions in the "All Assets" Access Group.

While the UI shows you have complete access, the exports have been restricted. The solution is to explicitly provide permissions to the admin user. Once you provide explicit permissions, run the navi update full command and you will see you have data.

— Reply to this email directly, view it on GitHub https://github.com/packetchaos/navi/issues/23#issuecomment-1063397098, or unsubscribe https://github.com/notifications/unsubscribe-auth/AASPYADFWHAFAK3MK6GDVMDU7EK33ANCNFSM5QKUAH6A . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

You are receiving this because you authored the thread.Message ID: @.***>

-- Kind Regards Neil Hazelwood 0211788070

packetchaos commented 2 years ago

You're welcome. Glad it worked out. Let me know if you have any other issues.

I'll close the issue out.