HCL BigFix CLM Predefined SQL Function List

Table 1. HCL BigFix CLM Predefined SQL Function List
S. No. Function Name Description
1 @@fnGetAPIUserName This function provides the API username to access HCL BigFix CLM API’s.
2 @@fnGetAPIUserPassword This function provides the API password name to access HCL BigFix CLM API’s.
3 @@fnGetARMAzureSubscriptionID This function provides the ARM Cloud Account subscription ID.
4 @@fnGetARMClientSecretKey This function provides the ARM Cloud Account client secret key.
5 @@fnGetARMNativClientID This function provides the ARM Cloud Account Native clientID.
6 @@fnGetARMTenantID This function provides the ARM Cloud Account tenant ID
7 @@fnGetAWSAccessKey This function provides the AWS Cloud Account access key
8 @@fnGetAWSAccountNo This function provides the AWS Cloud Account no.
9 @@fnGetAWSSecretKey This function provides the AWS Cloud Account secret key.
10 @@fnGetBladeLogicPlatformPassword This function provides the Bladelogic platform password associated with end point of a request.
11 @@fnGetBladeLogicPlatformUserName This function provides the Bladelogic platform username associated with end point of a request.
12 @@fnGetChefPlatformPassword This function provides the CHEF platform password associated with end point of a request.
13 @@fnGetChefPlatformUserName This function provides the CHEF platform username associated with end point of a request.
14 @@fnGetComponentPassword This function provides password to access component API of HCL BigFix CLM.
15 @@fnGetComponentUserName This function provides username to access component API of HCL BigFix CLM.
16 @@fnGetGetDomainName This function provides the domain name of organization of a request.
17 @@fnGetGetDomainPassword This function provides the domain password of organization of a request.
18 @@fnGetGetDomainUserID This function provides the domain userID of organization of a request.
19 @@fnGetOrgEntityID This function provides the OrgEntityId of Organization against the request.
20 @@fnGetPlatformEntityID This function provides Platform/Endpoint Entity Id associated with request.
21 @@fnGetPUPPETPlatformPassword This function provides the PUPPET platform password associated with end point of a request.
22 @@fnGetPUPPETPlatformUserName This function provides the PUPPET platform username associated with end point of a request.
23 @@fnGetSCCMPlatformPassword This function provides the SCCM platform password associated with end point of a request.
24 @@fnGetSCCMPlatformUserName This function provides the SCCM platform Username associated with end point of a request.
25 @@fnGetSCVMDomain This function provides the SCVM Domain Name associated with a request.
26 @@fnGetSCVMPassword This function provides the SCVM Password associated with a request.
27 @@fnGetSCVMPort This function provides SCVMM server with a port number
28 @@fnGetSCVMServerURL This function provides the SCVM server URL associated with a request.
29 @@fnGetSCVMUserName This function provides the SCVM username associated with a request.
30 @@fnGetSRRequestno This function provides complete request no.
31 @@fnGetTemplateName This function provides template name associated of request.
32 @@fnGetVMPassword This function provides default password which will create on newly added virtual machine through HCL BigFix CLM.
33 @@fnGetVMUserName This function provides default username which will create on newly added virtual machine through HCL BigFix CLM.
34 @@fnGetVMWARPassword This function provides the vcenter server password and it is encrypted associated with VMWAR Cloud Account.
35 @@fnGetVMWARServerURL This function provides the vcenter server url associated with VMWAR Cloud Account.
36 @@fnGetVMWARTemplatePath This function provides the vCenter template path where all the client’s templates are store VMWAR Cloud Account.
37 @@ fnGetVMWARUserName This function provides vcenter server username.
38 @@fnGetWebAPIUrl This function provides HCL BigFix CLM web API hosted URL.
39 @@fnGetGCPClientEmail This function provides the GCP Cloud Account Client Email.
40 @@fnGetGCPPrivateKey This function provides the GCP Cloud Account private key.
41 @@fnGetGCPPrivateKeyId This function provides the GCP Cloud Account private key id.
42 @@fnGetGCPProjectId This function provides the GCP Cloud Account project id.
43 @@fnGetGCPScopeURL This function provides the GCP Cloud Account scope url.
44 @@fnGetGCPTokenURL This function provides the GCP Cloud Account token url.
45 @@fnGetVMWARLocationName This function provides VMWAR Cloud Account Location.
46 @@fnGetVMWARRegionName This function provides VMWAR Cloud Account Region.
47 @@fnGetGeneratedVMName This function provides VM name associated of request.
48 @@fnGetServiceCatalogID This function provides the service catalog id.
49 @@fnGetRunOnceCommand This function provides the run once command.
50 @@fnGETXMLForRequestDetail This function provides the xml for request detail.
51 @@fnGetItemNo This function provides the Item no.
52 @@fnGetAnsibleConfiguration This function provides the ansible configuration details.
53 @@fnGetGitRepositoryPath This function provides the GIT repository path.
54 @@fnGetGitUserName This function provides the GIT username.
55 @@fnGetGitPassword This function provides the GIT password.
56 @@fnGetTerraformBackendBucketName This function provides the Terraform Bucket Name.
57 @@ fnGetTerraformBackendBucketRegion This function provides the Terraform bucket region.
58 @@ fnGetTerraformBackendBucketAccesskey This function provides the Terraform Cloud Account client Access key.
59 @@ fnGetTerraformBackendBucketSecretkey This function provides the Terraform Cloud Account client secret key.
60 @@ fnGetGitRepositoryType This function provides GIT repository types.
61 @@ fnGetTerraformParentWorkingDirectory This function provides the Terraform working directory.
62 @@fnGetTagJson This function provides the TAG json for Request.
63 @@fnGetCatalogName This function provides the service catalog name.
64 @@fnGetSRNumber This function provides the request SR Number.
65 @@fnGetAzureCustomImagePath This function provides the Azure Custom Image Complete Path.
66 @@fnGetProviderAPIUserName This function provides the provider API user password.
67 @@fnGetUCSDConfiguration This Function provides the UCSD Configuration details.
68 @@ fnGetObjectID This function provides the Object id of CI.
69 @@ fnGetPowerStatus This function provides the Power Status of CI.
70 @@ fnGetResourceGroup This function provides the Resource Group of CI.
71 @@ fnGetDataCenterName This function provides the Data Center Name of CI.
72 @@ fnGetCIRegionName This function provides the Region Name of CI.
73 @@ fnGetCILocationName This function provides the Location Name of CI.
74 @@fnGetMachinename This function provides the Machine Name of CI.
75 @@fnGetIntersightConfiguration This function provides the CONFIGUREATION of CI.
76 @fnGetOCPApiVersion This function provides the OCP API version.
77 @FnGetOCPNameSpaceUID This function provides the OCP NameSpaceUID.
78 @fnGetOCPPassword This function provides the OCP Cloud Account Password.
79 @fnGetOCPUserName This function provides the OCP Cloud Account Username.
80 @fnGetOCPVMLabels This function provides the OCP Label.
81 @fnGetOCPVMNetworkDetails This function provides the OCP Virtual Machine Network Details.
82 @fnGetOCPVMTemplateOS This function provides the OCP Template OS.
83 @fnGetOCPVMType This function provides the OCP VM Type.
84 @GetOCPJobTypeCodeURL This function provides the OCP Jobtype Code URL.
85 @GetOCPTokenURL This function provides the OCP Token URL.