SCCM SQL Query to extract machine name and its last reboot timestamp

Select sys.Netbios_Name0 AS Machine_Name, os.lastbootuptime0 AS Last_Boot_time
from v_r_system sys
inner join  v_FullCollectionMembership col on sys.resourceid=col.resourceid
left join v_gs_operating_system os on sys.resourceid=os.resourceid
where col.CollectionID = 'collectionID'

Give the collection Id and execute the report