V7.5 change in report break functionality
Under v7 environment the following query report produced breaks on change of IP Class, so all the 192.168.1.x had a break before them with 192.168.1.0 as the header.
Running same report in V7.5 just gives an unbroken list.
For me it would be nice to have the V7 functionality back.
Regards,
Andy
Running same report in V7.5 just gives an unbroken list.
For me it would be nice to have the V7 functionality back.
Regards,
Andy
select sysi.WORKSTATIONNAME, rs.RESOURCENAME "Resource Name",ddefn.DEPTNAME "Department",aorg.NAME "Site",networkinfo.IPADDRESS 'IPAddress',networkinfo.MACADDRESS "MAC Address",networkinfo.Network 'VLAN Segment',state.DISPLAYSTATE 'Status' from SystemInfo sysi
left join networkinfo on sysi.WORKSTATIONID=networkinfo.WORKSTATIONID left join Resources rs on rs.RESOURCEID=sysi.WORKSTATIONID left join ResourceOwner rso on rso.RESOURCEID=rs.RESOURCEID left join DepartmentDefinition ddefn on ddefn.DEPTID=rso.DEPTID LEFT JOIN SiteDefinition sdefn on sdefn.SITEID=ddefn.SITEID LEFT JOIN AaaOrganization aorg on aorg.ORG_ID=sdefn.SITEID LEFT JOIN ResourceState state ON rs.RESOURCESTATEID=state.RESOURCESTATEID where networkinfo.IPADDRESS <> '0.0.0.0' and rs.RESOURCESTATEID <> 5 order by 7,5