create view umcs as select distinct username,visibleip,reportedfqdn,systemserialnumber,chassisassettag from loggedevent where sampletime > (now() - interval '1 month') and event ='who';
select distinct visibleip,reportedfqdn,systemserialnumber,chassisassettag,count(username) from umcs group by visibleip,reportedfqdn,systemserialnumber,chassisassettag;
visibleip | reportedfqdn | systemserialnumber | chassisassettag | count
-----------------+-------------------------------------+--------------------------------------+-----------------+-------
<snipped for privacy reasons> | 0911TF414W | Null Null | 3
<snipped for privacy reasons> | FF0008FF-FFFF-FFFF-FFFF-64B314282100 | Not Specified | 1
<snipped for privacy reasons> | CZC90150YX | CZC8161XB9 | 1
<snipped for privacy reasons> | CZC849383L | CZC818276N | 3
<snipped for privacy reasons> | HUB652024J | HUB652024J | 2
<snipped for privacy reasons> | CZC8310N2J | CZC8310N2J | 1
<snipped for privacy reasons> | CZC8310N2D | CZC8310N2D | 1
<snipped for privacy reasons> | CZC8310N1Z | CZC8310N1Z | 1
<snipped for privacy reasons> | CZC7083RPF | CZC7083RPF | 1
<snipped for privacy reasons> | CZC64600SZ | CZC64600SZ | 1
<snipped for privacy reasons> | CZC7083RRL | CZC7083RRL | 1
<snipped for privacy reasons> | CZC7083RRN | CZC7083RRN | 1
<snipped for privacy reasons> | CZC64600TS | CZC64600TS | 1
<snipped for privacy reasons> | CZC64600ZW | CZC64600ZW | 1
<snipped for privacy reasons> | CZC64600XT | CZC64600XT | 1
<snipped for privacy reasons> | CZC7083RMK | CZC7083RMK | 1
<snipped for privacy reasons> | CZC64600YW | CZC64600YW | 1
<snipped for privacy reasons> | CZC9185ZHW | CZC8450NNR | 1
<snipped for privacy reasons> | CZC7083RLB | CZC7083RLB | 2
<snipped for privacy reasons> | CZC7083RNV | CZC7083RNV | 1
<snipped for privacy reasons> | CZC41612B3 | | 1
(21 rows)