I have used below in the where clause, but it is not pulling the right data set.
nodes.LastBoot >= GetUTCDATE() - 180
Try nodes.LastBoot >= (GetUTCDATE() - 180) or DAYDIFF(nodes.LastBoot, GETDATE())>180