Salesforce Insight Manager is a Windows Forms desktop application built with .NET Framework 4.8 (C# 7.3) that provides advanced reporting, dashboard auditing, and user activity analysis for Salesforce environments. It is designed for business users, administrators, and analysts who need deeper insight and control over Salesforce data usage, access, and security.

• Inactive Employees Reports

  • Retired or withdrawn users
  • Inactive but not retired/withdrawn

• User Activity Tracking

  • Inactive users (no login for 180+ days)
  • Active users not running reports (180+ days)

• Public Reports Not Used (90+ days)

• Public and private dashboards usage
• Detect unused or underutilized dashboards
• Component-level dashboard insights

• Track who has access to what Salesforce folders
• Audit sharing and permission structures

• Export reports directly to Excel
• Upload Excel ignore lists to exclude records from analysis

• All credentials and endpoints are configured via App.config.
• Uses SforceService for SOAP API access.
• Optionally supports OAuth2 with sfdcConsumerKey, sfdcConsumerSecret.

• Frontend: WinForms (.NET Framework 4.8)
• Backend: C# business logic using Salesforce SOAP API
• Excel Parsing: LinqToExcel for ignore list uploads
• UI Assets: Managed through embedded image resources

SalesforceWindowsForms/
├── CollectionObjects/        # Data models for reports and dashboards
├── DAL/                      # Data Access Layer – handles API calls and queries
├── Properties/               # Assembly and app settings
├── Resources/                # Embedded images, icons, and other UI assets
├── View/                     # Windows Forms UI components and controls
├── Web References/SFDC/      # Salesforce SOAP API client (auto-generated from WSDL)
├── App.config                # App settings including Salesforce credentials and endpoints
├── Form1.cs / Form1.Designer.cs / Form1.resx  # Main form UI and logic
├── Program.cs                # Application entry point
├── SalesforceWindowsForms.csproj # Project file
├── packages.config           # NuGet package dependencies
├── README.md                 # This documentation file
├── .gitignore, .gitattributes
├── SalesforceWindowsForms.sln  # Visual Studio solution file

1. Clone the repo

   git clone https://github.com/aimaster-dev/salesforce-insight-manager.git

2. Open in Visual Studio (2019 or later recommended)

3. Set up App.config with your Salesforce credentials:

   <appSettings>
     <add key="UserName" value="your_salesforce_username"/>
     <add key="Password" value="your_password_with_security_token"/>
     <add key="ServerURLsoap" value="https://login.salesforce.com/services/Soap/u/54.0"/>
   </appSettings>

4. Run the application (Ctrl + F5)

• Do not hardcode credentials in code.
• Make sure App.config is excluded from version control if storing sensitive data.
• OAuth2 support available but not enabled by default.

This app is ideal for:

• Salesforce Admins
• Business Analysts
• IT Security Auditors
• Operations Managers needing user or asset visibility in Salesforce

• Full integration with Salesforce REST API via OAuth2
• Automated scheduling/reporting
• Role-based access controls for app features
• Real-time report run status monitoring

This project is under the MIT License.