cancel
Showing results for 
Search instead for 
Did you mean: 

Fields of the Nsight database

Fields of the Nsight database

Jose_LV
New Contributor III
Hi

I have made a backup of the Nsight database. I have decompressed the resulting tar.gz with a large number of .bson files.

97aa10682fb14510af7ab20b1e5d6b92_RackMultipart20180917-64805-1bbpesh-bson_inline.jpg



I have taken one of these .bson files and I have converted it to .csv, and its contents are a large number of lines with the following structure:

{"_id":"2018-08-15T04:40:00@Nortconsulting","metadata":[{"f1":"www.google.com","f2":"43D07091","f3":[{"ch":1,"mumac":"D8C77104520B","s3":1860,"s2":961,"s1":1,"s5":17465,"s4":2821}],"s3":1860,"s2":961,"s1":1,"type":"http","s5":17465,"s4":2821},{"f1":"captivenortconsulting.com:880","f2":"293C9EA2","f3":[{"ch":1,"mumac":"D8C77104520B","s3":10905,"s2":4043,"s1":1,"s5":17466,"s4":14948}],"s3":10905,"s2":4043,"s1":1,"type":"http","s5":17466,"s4":14948}],"ts":{"$date":"2018-08-15T04:40:00.000Z"},"rfd":"Nortconsulting"}

I can guess what correspond some fields that mark in bold such as date, time, rf-domain, visited page, the client's mac, the captive portal through which the client connects.

Can someone tell me what is the meaning of the fields in which the .bson files are structured in the Nsight database?

The purpose I want to reach is to be able to see all the pages that all my clients visit.


Thanks

0 REPLIES 0
GTM-P2G8KFN