![]() ![]() ![]() Note: Please replace the single quotes from your Key board as it might give you syntax error when you do copy/paste. Natively SCCM only supports very minimal Mac features with Parallels installed a wide feature array is supported allowing you to fully manage your Mac desktops from SCCM. Hi, I have a below SQL query to get the machines information with one MAC address. Select CollectionID,Name from v_Collection Leverage native Microsoft SCCM reports for details on Mac computers. Group by A.Name0,c.IPAddress0 ,E.UserName0 Inner join v_GS_COMPUTER_SYSTEM E ON A.ResourceID=E.ResourceID Inner join v_GS_NETWORK_ADAPTER_CONFIGUR C ON Select A.Name0,c.IPAddress0 as 'IP ADDRESS',E.UserName0 as 'Lastlogged user' This report gives you computers with ip address and last logged on username from a given collection : Long ago have posted report on computers with SCCM report for Last logged on computer name with application installed or not and SCCM report display computers with IPaddress based on Application/software ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |