There are a few different ways to pull what you want. Need more info. Computer Name = netbios_name0 from v_r_system
Type = chassis_type0 from v_gs_system_enclosure User name = Which one do you want? See links below. http://myitforum.com/myitforumwp/2014/06/10/where-to-find-user-name-data-in-configuration-manager-part-1/ http://myitforum.com/myitforumwp/2014/06/11/where-to-find-user-name-data-in-configuration-manager-part-2/ Last activity date = What activity? Last heartbeat? Last contact to the MP? Last hardware scan? Most fields are in v_ch_clientsummary. Daniel Ratliff From: [email protected] [mailto:[email protected]] On Behalf Of Radu Bogdan Sent: Tuesday, April 07, 2015 7:47 AM To: [email protected] Subject: [mssms] Custom report Hello, Does any one know how to create a custom report with the following columns: Computer name, Type ( servers, desktops or laptops ), User name, Last activity date. Thank you. Regards. The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
