Tag Archives: Counts
Still counts, right?!
About Krisgo
I’m a mom, that has worn many different hats in this life; from scout leader, camp craft teacher, parents group president, colorguard coach, member of the community band, stay-at-home-mom to full time worker, I’ve done it all– almost! I still love learning new things, especially creating and cooking. Most of all I love to laugh! Thanks for visiting – come back soon 
When Every Second Counts
When I first agreed to take on the role of managing the Cloud Operations team for tibbr, TIBCO’s enterprise social networking SaaS application, I knew that the job would be no cakewalk. There would be plenty of challenges involved with ensuring that this mission-critical cloud service remained up and running 24×7 for companies around the world. Fast forward to 2017—and I’ve never looked back at that decision—it’s been an exciting and rewarding journey.
Part of what helps make my job manageable is choosing the right infrastructure and tools. For example, using TIBCO LogLogic has been a tremendous help to collect, manage, and leverage log data from the various components of our cloud infrastructure so that we can track activities and conditions of interest.
LogLogic’s out-of-box reports and dashboard provide the necessary information at our fingertips to meet our compliance, reporting, and auditing needs. As part of our Federal Risk and Authorization Management Program (FedRAMP) certification, for example, tibbr has proven that it meets high standards for continuous monitoring of security-related data as well as tracking related continuous updates. Our team relies on LogLogic to help ensure the completeness and integrity of the necessary security records and history to meet those requirements.
LogLogic also helps us to meet the availability goals needed for our cloud service, sending alerts when certain conditions are detected or thresholds are met, so that we can proactively take action to avert potential issues.
When issues are detected, LogLogic’s flexible search capabilities help us quickly mine through our mountains of valuable log data to find key information for faster resolution. We are excited that LogLogic 6.1 now makes that search even faster than ever—because when your team is on the hook for ensuring the uptime of an enterprise-class cloud service, every second counts.
Find out more about LogLogic 6.1 with a video playlist and on the TIBCO Community.
China Mobile Now Counts 430 Million 4G Users
The number of people using fast wireless services from China Mobile is larger than the population of the United States.
Chinese telecom operator China Mobile recently published its operating statistics for June 2016, wand the company showed that the company continued to lead the 4G sector and left its two competitors China Unicom and China Telecom far behind.
By June 30, 2016, China Mobile’s number of 4G users reached 428.541 million. During that month, the company gained 19.225 million new 4G users, which was the second best performance over the first half of 2016 following January. The population of the United States, according to U.S.-based Census.gov, is 324 million.
Meanwhile, China Mobile reported total number of users of 837.038 million, representing an average monthly increase of 1.8 million users. However, its 3G users saw an average monthly decrease of 6.085 million to 132.865 million users. The number of its broadband users reached 65.836 million by the end of June 2016. During the first half of the year, China Mobile gained 10.807 million new broadband users, with an average monthly increase of 1.801 million users.
According to reports in Chinese local media, by the end of June 2016, China Unicom had 72.417 million 4G users and China Telecom had 90.1 million 4G users.
Determining Total Record Counts
If you are familiar Microsoft CRM, then you know that one it’s great features is the ability to store thousands of records for your organization so that you can report on that data for effective decision making. There is one challenge though – in CRM 2015 (pre-spring release) and earlier versions. Say you want to know how many Active Contacts records you have. When you pull up the list of your Active Contacts, you get 1-250 of 5000+ indicator at the bottom left corner of the list view.
Ahhhhh, the frustration! But don’t lose hope! There are a couple of things you can do to find the exact number you are looking for, and in today’s blog, we will show you how!
If you have under 10,000 records, you can use the Export to Excel feature and export all the records in the current view.
Simply scroll to the end of the worksheet to determine how many records were exported. Keep in mind, if the total number of rows reaches 10,001 it means that you have more than 10,000 records and all of the records that meet the query criteria were not exported. Microsoft CRM limits the number of records exported to Excel to 10,000 in order to minimize the potential inadvertent performance impact of large queries on the system.
But all hope is not lost! Use the following trick to get the exact number of records in your query with a quick customization. You’ll need a security role with Customizer privileges to perform these changes.
First, navigate to Customizations.
1. Click on Fields under
the entity for which you need the record count.
2. Create a custom attribute with data type “Single Line of text” called “Total Count”. There is no need to add this new field to the entity form.
3. Then Publish your customizations.
4. Now, create a New Report with the Report Wizard. You’ll need the necessary permissions to do so.
5. In the Report Wizard, enter a Report Name and select the Contact entity (in our example) in the Primary record type drop-down menu.
6. In the next window, you can choose a previously saved view or create all new Report Filtering Criteria. To get the full record count (both Inactive and Active records), clear the filter criteria completely before clicking the Next button.
7. In the Add Grouping window, select Total Count from the Column drop-down menu. Then select Count from the Summary Type drop-down menu.
8. To add a column to the report layout, select Click here to add a column. The Column drop-down menu will default to Full Name. Leave that and select OK.
9. In the Format Report window, select Table only.
10. Finish the report. And then run it to view the results!
And there you go folks, the total count of all your records! You can also export the records into Excel from the report if desired.
These quick tricks will help you the next time you need to retrieve the total number of records from an entity like Contacts in CRM 2015 (pre-Spring release) and earlier versions!
Happy CRM’ing!
This entry passed through the Full-Text RSS service – if this is your content and you’re reading it on someone else’s site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.