I need to create a software report include include field
Check the forum
How to Collect and View Detailed and Summary File Inventory Data for Any File Type/Extension
You can go with this report and find the software data
Reports > Discovery and Invnetory > Cross-Platform > Software/Applications > Software > "Installed Software" or "Installed Software by Computer"
why you don't use default "Audit Software Search" report from Inventory Solution, which contains more that you've mentioned fields in it?
Reports ⇒ Discovery and Inventory ⇒ Inventory ⇒ Cross-Platform ⇒ Software/Applications ⇒ General Software ⇒ Audit Software Search report.
Also you can clone this "Audit Software Search" report ⇒ open it ⇒ click on "Edit" ⇒ copy SQL Query and remove unnecessary fields for you to leave only required.