Hi
I have made a backup of the Nsight database. I have decompressed the resulting tar.gz with a large number of .bson files.
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
I have made a backup of the Nsight database. I have decompressed the resulting tar.gz with a large number of .bson files.
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
