+ Reply to Thread
Results 1 to 4 of 4
This is a discussion on Profile Report w/ PHP API within the Salesforce Coding Discussions forums, part of the Salesforce category; I'm looking to run a report of the internal users profile so
  1. #1
    ppafford is offline Junior Member
    Join Date
    Sep 2009
    Posts
    21

    Question Profile Report w/ PHP API

    I'm looking to run a report of the internal users profile so I can view user permissions, is there anything from the API that might do this?

    Specifically Administration Setup->Manage Users->Profiles->Profile Names is the information I need for all users in a report(excel) format.
    Last edited by ppafford; 10-28-2009 at 09:55 AM. Reason: correction

  2. #2
    ppafford is offline Junior Member
    Join Date
    Sep 2009
    Posts
    21
    Ok here is what I have so far but it's not pulling the info I exactly need yet, a little help would be great on this. Thanks in advance!!!

    PHP Code:
    // I'm using the login code from Mike's example: here

    // Create the SOQL sf query
    $sfQuery =<<<SFSQL
    SELECT 
    Profile.PermissionsViewSetup,
    Profile.PermissionsViewAllData,
    Profile.PermissionsUseTeamReassignWizards,
    Profile.PermissionsTransferAnyLead,
    Profile.PermissionsTransferAnyEntity,
    Profile.PermissionsSolutionImport,
    Profile.PermissionsSendSitRequests,
    Profile.PermissionsRunReports,
    Profile.PermissionsPublishMultiforce, 
    Profile.PermissionsPasswordNeverExpires,
    Profile.PermissionsOutboundMigrationToolsUser,
    Profile.PermissionsModifyAllData,
    Profile.PermissionsMassInlineEdit,
    Profile.PermissionsManageUsers,
    Profile.PermissionsManageSolutions,
    Profile.PermissionsManageSelfService,
    Profile.PermissionsManageMobile,
    Profile.PermissionsManageLeads,
    Profile.PermissionsManageDashboards,
    Profile.PermissionsManageCustomReportTypes,
    Profile.PermissionsManageCssUsers,
    Profile.PermissionsManageCategories,
    Profile.PermissionsManageCases,
    Profile.PermissionsManageCallCenters,
    Profile.PermissionsInstallMultiforce,
    Profile.PermissionsInboundMigrationToolsUser,
    Profile.PermissionsImportLeads,
    Profile.PermissionsEditTask,
    Profile.PermissionsEditReports,
    Profile.PermissionsEditReadonlyFields,
    Profile.PermissionsEditPublicDocuments,
    Profile.PermissionsEditOppLineItemUnitPrice,
    Profile.PermissionsEditEvent,
    Profile.PermissionsDisableNotifications,
    Profile.PermissionsCustomizeApplication,
    Profile.PermissionsCreateMultiforce,
    Profile.PermissionsConvertLeads,
    Profile.PermissionsAuthorApex,
    Profile.PermissionsApiUserOnly,
    Profile.PermissionsApiEnabled,
    Profile.Name,
    (
        SELECT 
            Id, Username, LastName, FirstName 
        FROM 
            Users


    FROM Profile
        
    SFSQL;

    /* NOT WORKING

     Profile.PermissionsTransferAnyCase,
     Profile.PermissionsScheduleReports,
     Profile.PermissionsScheduleJob,
     Profile.PermissionsManageRemoteAccess,
     Profile.PermissionsManageBusinessHourHolidays,
     Profile.PermissionsManageAnalyticSnapshots,
     Profile.PermissionsEditCaseComments,
     
     */
        
    // Query for account id's
    $response $sfConnection->query($sfQuery);

    $display print_r($response,true);

    // Displays some info but I would like to to drill down into more of each users profile permissions. 
    echo "<pre>".$display."</pre>"

  3. #3
    ppafford is offline Junior Member
    Join Date
    Sep 2009
    Posts
    21
    Sorry forgot to mention I'm using the PHP Toolkit 11

  4. #4
    ppafford is offline Junior Member
    Join Date
    Sep 2009
    Posts
    21
    Ok here is what I'm getting

    Code:
    stdClass Object (     
       [done] => 1     
       [queryLocator] =>      
       [records] => Array         
          (             
             [0] => stdClass Object                 
                (                     
                   [type] => Profile                     
                   [Id] => Array                         
                      (                             
                         [0] => 00e50000000o36GAAQ                             
                         [1] => 00e50000000o36GAAQ                         
                      )                      
                         [any] => Array                         
                            (                             
                               [0] => Standard100500000000BuWAAU2009-11-11T17:39:30.000ZtruetruetruetruetruetruetruetruetruefalsetruetruetruetruetruetruetruetruetruetruetruetruetruetruetruetruetruetruetruetruetruetruetruefalsetruetruetruetruefalsetrueSystem Administrator2009-11-11T17:39:30.000Z00550000001EnZwAAK
                               [1] => 2007-02-12T19:37:25.000Z00550000000wl8DAAQ                         
                            )                  
                      ) 
    etc...
    This value here is what I need but it comes as one value and not broken up into an array for each value. How can I change my query to get these values in a array?

    Code:
    [0] => Standard100500000000BuWAAU2009-11-11T17:39:30.000ZtruetruetruetruetruetruetruetruetruefalsetruetruetruetruetruetruetruetruetruetruetruetruetruetruetruetruetruetruetruetruetruetruetruefalsetruetruetruetruefalsetrueSystem Administrator2009-11-11T17:39:30.000Z00550000001EnZwAAK

+ Reply to Thread

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

SEO by vBSEO 3.5.2