![]() ![]() ![]() Inner join v_gs_computer_system on (v_gs_computer_system.reso urceid = v_r_system.resourceid) Inner join v_gs_system_enclosure on (v_gs_system_enclosure.res ourceid = v_r_system.resourceid) Inner join v_gs_PC_bios on (v_gs_pc_bios.resourceid = v_r_system.resourceid) Inner join v_GS_Operating_system on (v_gs_operating_system.res ourceid = v_R_system.resourceid) , v_GS_LOGICAL_DISK.FreeSpac e0 AS "Free Disk Space (MB)" , v_GS_LOGICAL_DISK.size0 AS "Disk Space (MB)" , v_gs_processor.maxclockspe ed0 AS "Processor (GHz)" , v_GS_x86_PC_memory.totalph ysicalmemo ry0 AS "Memory (KBytes)" , v_GS_Computer_system.model 0 AS "Model" , v_GS_Computer_system.manuf acturer0 AS "Manufacturer" , v_gs_Operating_system.csdv ersion0 AS "Service Pack Level" , v_R_System.Operating_Syste m_Name_and 0 AS "Operating System" , v_R_System.User_Name0 AS "Last Logged on User" Select distinct v_R_System.Netbios_Name0 AS "Computer Name" SQL Report that works fine: - (Does not show mac addresses). If anyone needs the SQL views from SCCM and can locate and send if it helps. All of the experts here have never let me down so I'm confident that someone here can help me resolve this issue. If someone could modify the code for me to add the MAC address colum and name each adpater, I would really appriciate it. The report displays fine but when I try to modify it to add the mac address column I get error as I don't really know SQL. ![]() I have a SCCM report that works perfectly, the only thing is that I need to add a column that adds the mac address for each computer along with the name of each adapter so if there is more than one mac address I can decipher the best one to use. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |