Discover whether the OS Architecture is 32 or 64 bit

InsightVM
1

Hi, I’m trying to find the OS Architecture version of the operating system, is this possible as I can’t find the field in the schema

2

There is an architecture column in dim_operating_system that might help. I found it mentioned in the sql repository in one of the queries there (https://github.com/rapid7/insightvm-sql-queries/blob/master/sql-query-export/Asset-Inventory.sql). Could modify that query and add in an architecture column- or if you just want to test to see what it looks like do something like this …

select da.ip_address, da.host_name, dos.architecture
from dim_asset da
JOIN dim_operating_system as dos ON da.operating_system_id = dos.operating_system_id

hope that helps

3

Great thanks!