Add EoS Date

1.Use short hostname instead of full domain name
2.Add EoS date query
3.Create a new view based on dbo.vUpdateExtended ( just trim the
fulldomainname to hostname)
4.Datevalue function to trim time part out of datetime value.