From the SEPM, you'd run the Computer Status report and export to csv and drop into excel. There would be columns to indicate which components are installed on the clients.
As for scripting, this powershell script is the best I've found and frankly is great:
https://gallery.technet.microsoft.com/scriptcenter/Symantec-Endpoint-8e47c450/view/Discussions