|By Richard Schwendiman||
|March 15, 2014 08:44 PM EDT||
After receiving multiple requests for a way to report on Lync Persistent Chat Archive Data (from the mgccomp Compliance database) I decided to create this sample report. One problem with querying for this data directly from the mgccomp database is that the Persistent Chat rooms aren't listed by name and the Messages are in RTF format. This sample report will take care of all the data conversion and put that data into a presentable report. Currently this sample report will only work against Lync 2013 Persistent Chat Archiving data in the mgcomp database.
· Ability to filter data based on Start and End dates, UserURI, or Persistent Chat Room
· Export this report into CSV, PDF, and Word formats
· Currently when a file has been uploaded to the Persistent Chat room the report will show a blank space in the Messages field. This will hopefully be resolved in the next version. The plan is to include a link to where the file is stored on the Persistent Chat file store.
· SQL Mirroring support. Currently you would need to change that data source if the primary SQL server for the Persistent Chat databases fails over to mirror. Follow Step 5 from the Report Installation section to change this value.
· PDF Export doesn’t display the data correctly.
· SQL Reporting Services Server (SRSS) – if you have deployed Lync Monitoring Reports then you should be able to use that same SRSS instance
· Permissions – in order to run this report you must have permissions to query both the mgccomp (Persistent Chat Compliance) and mgc (Persistent Chat Data) databases.
1. Download and Unzip the Reports from http://gallery.technet.microsoft.com/Sample-Persistent-Chat-8ff37d5e. Copy the Persistent Chat Archive Report.rdl file to the SRSS server.
2. Open Report Manager on the SRSS server via https://<SRSS Server Name>/Reports
3. Click on "New Folder", give it a name e.g. "Persistent Chat Archive", and click OK
4. Click on the newly created folder and select "Upload File". Click Browse and navigate to the location you copied the zip file from Step 1. Click on the "Persistent Chat Archive Report.rdl" file and select Open. Click OK which will upload the report.
5. Configure the report to utilize your SQL servers.
a. Click on the drop-down button for the "Persistent Chat Archive Report" and select "Edit in Report Builder".
b. Expand the Data Sources folder, right click "mgccomp", and select Data Source Properties.
c. On the General tab look under the section name Connection string. Change this value to Data Source=<SQL Server FQDN\Instance>;Initial Catalog=mgccomp.
i. E.g. Data Source=FABSQL1.fabrikam.com;Initial Catalog=mgccomp
d. Click OK
e. Click Save on the toolbar or press Ctrl + S
6. Close Report Builder
1. Open Report Server on the SRSS server https://<SRSS Server Name>/ReportServer
2. Click on the directory created in step 3 during Report Installation (e.g. "Persistent Chat Archive")
3. Click on the "Persistent Chat Archive Report" link which will take you into the report
4. Default Values
a. StartDate (required)– this will pull the current date of the SRSS server and subtract 1 day
b. EndDate (required)– this will pull the current date of the SRSS server and add 1 day
c. UserURI – (NULL)
d. Persistent Chat Room – (NULL)
5. Filtering Data – you can filter data based on any of the 4 parameters above. The filters are cumulative so if you select to filter on UserURI and Persistent Chat Room the results will only show IMs by the specified user in the specified chat room.
a. UserURI – users SIP address.
b. Persistent Chat Room – exact match on the room name including spaces.
6. Results – by default the report is configured to display the results of Date Created as UTC time. You can change this to the local time zone of the report server if needed.
a. Open the report in Report Builder, right click on the field under "Date Created (UTC)", and select "Expression"
b. Under "Set expression for: Value" paste this =TimeZone.CurrentTimeZone.ToLocalTime(Fields!entryDate.Value)
c. Click OK and then Save or press Ctrl + S
d. Rerun the report
i. Prior to change
ii. Post Change
7. Exporting Data to Word, XML, Excel, or CSV
a. After generating the report click on the save icon on the taskbar and choose your format.
The IoT is changing the way enterprises conduct business. In his session at @ThingsExpo, Eric Hoffman, Vice President at EastBanc Technologies, discuss how businesses can gain an edge over competitors by empowering consumers to take control through IoT. We'll cite examples such as a Washington, D.C.-based sports club that leveraged IoT and the cloud to develop a comprehensive booking system. He'll also highlight how IoT can revitalize and restore outdated business models, making them profitable...
May. 25, 2016 04:45 PM EDT Reads: 2,491
Designing IoT applications is complex, but deploying them in a scalable fashion is even more complex. A scalable, API first IaaS cloud is a good start, but in order to understand the various components specific to deploying IoT applications, one needs to understand the architecture of these applications and figure out how to scale these components independently. In his session at @ThingsExpo, Nara Rajagopalan is CEO of Accelerite, will discuss the fundamental architecture of IoT applications, ...
May. 25, 2016 04:45 PM EDT Reads: 925
In his session at 18th Cloud Expo, Bruce Swann, Senior Product Marketing Manager at Adobe, will discuss how the Adobe Marketing Cloud can help marketers embrace opportunities for personalized, relevant and real-time customer engagement across offline (direct mail, point of sale, call center) and digital (email, website, SMS, mobile apps, social networks, connected objects). Bruce Swann has more than 15 years of experience working with digital marketing disciplines like web analytics, social med...
May. 25, 2016 04:00 PM EDT Reads: 1,174
SYS-CON Events announced today that Enzu, a leading provider of cloud hosting solutions, will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. Enzu’s mission is to be the leading provider of enterprise cloud solutions worldwide. Enzu enables online businesses to use its IT infrastructure to their competitive advantage. By offering a suite of proven hosting and management services, Enzu wants companies to foc...
May. 25, 2016 03:45 PM EDT Reads: 2,109
Customer experience has become a competitive differentiator for companies, and it’s imperative that brands seamlessly connect the customer journey across all platforms. With the continued explosion of IoT, join us for a look at how to build a winning digital foundation in the connected era – today and in the future. In his session at @ThingsExpo, Chris Nguyen, Group Product Marketing Manager at Adobe, will discuss how to successfully leverage mobile, rapidly deploy content, capture real-time d...
May. 25, 2016 02:45 PM EDT Reads: 1,426
A strange thing is happening along the way to the Internet of Things, namely far too many devices to work with and manage. It has become clear that we'll need much higher efficiency user experiences that can allow us to more easily and scalably work with the thousands of devices that will soon be in each of our lives. Enter the conversational interface revolution, combining bots we can literally talk with, gesture to, and even direct with our thoughts, with embedded artificial intelligence, wh...
May. 25, 2016 02:30 PM EDT Reads: 1,858
IoT generates lots of temporal data. But how do you unlock its value? How do you coordinate the diverse moving parts that must come together when developing your IoT product? What are the key challenges addressed by Data as a Service? How does cloud computing underlie and connect the notions of Digital and DevOps What is the impact of the API economy? What is the business imperative for Cognitive Computing? Get all these questions and hundreds more like them answered at the 18th Cloud Expo...
May. 25, 2016 02:15 PM EDT Reads: 2,122
As cloud and storage projections continue to rise, the number of organizations moving to the cloud is escalating and it is clear cloud storage is here to stay. However, is it secure? Data is the lifeblood for government entities, countries, cloud service providers and enterprises alike and losing or exposing that data can have disastrous results. There are new concepts for data storage on the horizon that will deliver secure solutions for storing and moving sensitive data around the world. ...
May. 25, 2016 02:00 PM EDT Reads: 1,129
What a difference a year makes. Organizations aren’t just talking about IoT possibilities, it is now baked into their core business strategy. With IoT, billions of devices generating data from different companies on different networks around the globe need to interact. From efficiency to better customer insights to completely new business models, IoT will turn traditional business models upside down. In the new customer-centric age, the key to success is delivering critical services and apps wit...
May. 25, 2016 01:45 PM EDT Reads: 930
The essence of data analysis involves setting up data pipelines that consist of several operations that are chained together – starting from data collection, data quality checks, data integration, data analysis and data visualization (including the setting up of interaction paths in that visualization). In our opinion, the challenges stem from the technology diversity at each stage of the data pipeline as well as the lack of process around the analysis.
May. 25, 2016 12:45 PM EDT Reads: 1,174
SYS-CON Events announced today that ContentMX, the marketing technology and services company with a singular mission to increase engagement and drive more conversations for enterprise, channel and SMB technology marketers, has been named “Sponsor & Exhibitor Lounge Sponsor” of SYS-CON's 18th Cloud Expo, which will take place on June 7-9, 2016, at the Javits Center in New York City, New York. “CloudExpo is a great opportunity to start a conversation with new prospects, but what happens after the...
May. 25, 2016 11:00 AM EDT Reads: 847
SYS-CON Events announced today that MangoApps will exhibit at SYS-CON's 18th International Cloud Expo®, which will take place on June 7-9, 2016, at the Javits Center in New York City, NY. MangoApps provides modern company intranets and team collaboration software, allowing workers to stay connected and productive from anywhere in the world and from any device. For more information, please visit https://www.mangoapps.com/.
May. 25, 2016 10:15 AM EDT Reads: 416
SYS-CON Events announced today that 24Notion has been named “Bronze Sponsor” of SYS-CON's 18th Cloud Expo, which will take place on June 7-9, 2016, at the Javits Center in New York, New York. 24Notion is full-service global creative digital marketing, technology and lifestyle agency that combines strategic ideas with customized tactical execution. With a broad understand of the art of traditional marketing, new media, communications and social influence, 24Notion uniquely understands how to con...
May. 25, 2016 09:45 AM EDT Reads: 1,709
WebRTC is bringing significant change to the communications landscape that will bridge the worlds of web and telephony, making the Internet the new standard for communications. Cloud9 took the road less traveled and used WebRTC to create a downloadable enterprise-grade communications platform that is changing the communication dynamic in the financial sector. In his session at @ThingsExpo, Leo Papadopoulos, CTO of Cloud9, will discuss the importance of WebRTC and how it enables companies to fo...
May. 25, 2016 04:45 AM EDT Reads: 2,440
SYS-CON Events announced today TechTarget has been named “Media Sponsor” of SYS-CON's 18th International Cloud Expo, which will take place on June 7–9, 2016, at the Javits Center in New York City, NY, and the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. TechTarget is the Web’s leading destination for serious technology buyers researching and making enterprise technology decisions. Its extensive global networ...
May. 25, 2016 04:15 AM EDT Reads: 3,052
Korean Broadcasting System (KBS) will feature the upcoming 18th Cloud Expo | @ThingsExpo in a New York news documentary about the "New IT for the Future." The documentary will cover how big companies are transmitting or adopting the new IT for the future and will be filmed on the expo floor between June 7-June 9, 2016, at the Javits Center in New York City, New York. KBS has long been a leader in the development of the broadcasting culture of Korea. As the key public service broadcaster of Korea...
May. 25, 2016 04:00 AM EDT Reads: 1,718
With major technology companies and startups seriously embracing IoT strategies, now is the perfect time to attend @ThingsExpo 2016 in New York and Silicon Valley. Learn what is going on, contribute to the discussions, and ensure that your enterprise is as "IoT-Ready" as it can be! Internet of @ThingsExpo, taking place Nov 3-5, 2015, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with 17th Cloud Expo and will feature technical sessions from a rock star conference faculty ...
May. 24, 2016 06:00 PM EDT Reads: 4,684
The 19th International Cloud Expo has announced that its Call for Papers is open. Cloud Expo, to be held November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA, brings together Cloud Computing, Big Data, Internet of Things, DevOps, Containers, Microservices and WebRTC to one location. With cloud computing driving a higher percentage of enterprise IT budgets every year, it becomes increasingly important to plant your flag in this fast-expanding business opportunity. Submit y...
May. 24, 2016 05:00 PM EDT Reads: 1,873
There are several IoTs: the Industrial Internet, Consumer Wearables, Wearables and Healthcare, Supply Chains, and the movement toward Smart Grids, Cities, Regions, and Nations. There are competing communications standards every step of the way, a bewildering array of sensors and devices, and an entire world of competing data analytics platforms. To some this appears to be chaos. In this power panel at @ThingsExpo, moderated by Conference Chair Roger Strukhoff, panelists will discuss the vast to...
May. 24, 2016 04:00 PM EDT Reads: 2,383
Internet of @ThingsExpo, taking place November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with the 19th International Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world and ThingsExpo New York Call for Papers is now open.
May. 24, 2016 04:00 PM EDT Reads: 1,702