Reports
There are a number of 
SMP 
Reports pre-installed but you can also create your own.
---
I thought it might be helpful to document how to create Reports to get the most common information people require, this could be an Asset's Status, it's Location, Department, Inventory data etc. Sometimes the joins aren't obvious or you find a Report with some information but not all and you need to merge the two.
ToDo
- Inventory (AeX ...)
- Disk Space
- Last Check In Date
Please add links to any useful Reports you've found or made.
Please comment below for any Reports you'd like adding to the list.
---
SSE
I would advise adding the SSE Reports provided by 
Symantec, these are useful for any Support Cases you raise.
SSE Reports
HOWTO52986
https://support.symantec.com/en_US/article.HOWTO52986.html
SSE Reports for ITMS
TECH227522
https://support.symantec.com/en_US/article.TECH227522.html
ITMS 7.5 - Checking Agent Plug-ins versions via SMP reports
SSE SMP reports
Mauro Dalvit (https://www.symantec.com/connect/user/mauro-dalvit)
https://www.symantec.com/connect/blogs/itms-75-checking-agent-plug-ins-versions-smp-reports
---
Connect Group(s)
You can also join a Group which has useful Connect info:
Reporting
https://www.symantec.com/connect/groups/reporting
---
Symantec Articles
Of course check out any Articles from JS, he's written up a list of many of the pre-canned Reports:
Joel Smith (https://www.symantec.com/connect/user/joel-smith)
Software Management Resource Schema 7.1
https://www.symantec.com/connect/articles/software-management-resource-schema-71
Part 1: Discovery, Inventory, and Asset
List of Reports and Associated Queries within the Symantec Management Platform and Solutions 7.5 SP1, Part 1: Discovery, Inventory, and Asset
https://www.symantec.com/connect/articles/list-reports-and-associated-queries-within-symantec-management-platform-and-solutions-75-sp
Part 2: Software Management
List of Reports and Associated Queries within the Symantec Management Platform and Solutions 7.5 SP, Part 2: Software Management
https://www.symantec.com/connect/articles/list-reports-and-associated-queries-within-symantec-management-platform-and-solutions-75--0
Part 3: Symantec Management Platform
List of Reports and Associated Queries within the Symantec Management Platform and Solutions 7.5 SP1, Part 3: Symantec Management Platform
https://www.symantec.com/connect/articles/list-reports-and-associated-queries-within-symantec-management-platform-and-solutions-75--1
Part 4: Computer and Server Management
List of Reports and Associated Queries within the Symantec Management Platform and Solutions 7.5 SP1, Part 4: Computer and Server Management
https://www.symantec.com/connect/articles/list-reports-and-associated-queries-within-symantec-management-platform-and-solutions-75--2
Part 5: Other Management Solutions
List of Reports and Associated Queries within the Symantec Management Platform and Solutions 7.5 SP1, Part 5: Other Management Solutions
https://www.symantec.com/connect/articles/list-reports-and-associated-queries-within-symantec-management-platform-and-solutions-75--3
---
Helpful Reports
Symantec CMDB Reporting - How to find the right SQL Table
https://www.symantec.com/connect/videos/symantec-cmdb-reporting-how-find-right-sql-table
By: odami
SELECT * FROM INFORMATION_SCHEMA .COLUMNS WHERE COLUMN_NAME LIKE '%Software%'
Useful SQL queries concerning Collections/Filters
https://www.symantec.com/connect/articles/useful-sql-queries-concerning-collectionsfilters
By: sk
The SQL behind the Activity Center's "Manage > Software" console view
https://www.symantec.com/connect/articles/sql-behind-activity-centers-manage-software-console-view
By: sk
Understanding the ResourceAssociation table
https://www.symantec.com/connect/blogs/understanding-resourceassociation-table
By: sk
Query behind software view in Enhanced console views
https://www.symantec.com/connect/forums/query-behind-software-view-enhanced-console-views
---
Schemas
Symantec Management Platform 7.1 Database Schema
https://support.symantec.com/en_US/article.DOC3724.html
DOC3724
What is the Database structure (Schema)?
https://support.symantec.com/en_US/article.HOWTO1107.html
HOWTO1107
---
Symantec Support
How to create a custom report for assets
https://support.symantec.com/en_US/article.HOWTO100089.html
HOWTO100089